In this article, we will walk you through the step by step guide of how to use sort-by function in power bi.
Step 1: “Load a Dataset”
If you want to load your dataset, simply click on the “Get Data” button in the data group on the “Home Tab”. once you click on that it will show a drop-down menu with multiple data sources, select “Excel workbook” from there and click on that.
Once, you click on that it brings another dialog box, where you can pull your data file from your local system, select your file and click on “Open” button located at the bottom right corner of the dialog box.
Once, you are done with that it will bring a navigator dialog box, from there you can select your sheet from the left hand side and after that, simply click on the “Check Box” and select your “All” sheet. once you select, than click on “Load” button located at the bottom right corner of the dialog box for saving your changes.
Step 2: “Select a Column to Sort”
If you want to sort your data in ascending and descending order, depending on your preference, so click on the “three dots” icon at the top right corner in your data table. Once, you click on that it will popped up a dialog box, where you see a option named as “Sort by” click on that it will show your all column that is present in your dataset. now you click on your desired column after that it will sort it.
Conclusion:
In this article, we will shape out the concepts of sorting and also have a glimpses of why it is important when you have a several numeric columns.
