Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
We have a software that utilizes BI to report on its stored data.
There is a certain dashboard built that there is a hierarchy in place for how the data is displayed. Now the names of the headers for each hierarchy is what the entire dataset is ordered by. But these names are ordered alphanumerically which is causing an issue with the ordering.
For example: the headings are currently ordered B-1, B-10, and B-2. When they should be ordered B-1, B-2, B-10. This is included in a screenshot below. Is there a way to have BI reorder these without changing the hierarchy and keeping all of the data groups properly grouped together?
Solved! Go to Solution.
Add a column to your data model that indicates the desired sort order and then sort your header column by that column.
Sort one column by another column in Power BI - Power BI | Microsoft Learn
Add a column to your data model that indicates the desired sort order and then sort your header column by that column.
Sort one column by another column in Power BI - Power BI | Microsoft Learn
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
59 | |
20 | |
18 | |
18 | |
9 |