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.
Hi,
hoping someone can help me. I have a matrix with columns and rows and calculated values.
My client wants to be able to sort the rows in a specific order and then the values in descending order so the column Starting a Grant would be at the far left. I've managed to sort the trading status in pie charts and bar charts with only 1 dimension by creating a measure for each trading status and then adding as values and re-ordering that way. I can't seem to find a weay of doing this for the matrix though.
The below is a chart I have used measures for each of the trading status
Any help would be much appreicated.
Debra
Solved! Go to Solution.
hi, @Deb3107
Add a conditional calculate column by dax in Summary table
For example:
For sort=IF([Trading Status] ="Pre-Start",1
IF([Trading Status] ="Established 1-3 years",2
IF([Trading Status] ="Established 3-10 years",3
IF([Trading Status] ="Established >10 years",4))))
...
If there is other attribute, keep the same logic in the formula
Then use selected [Trading Status] filed in the right fields pane->Click Sort by Column->choose the new column.
https://radacad.com/sort-by-column-in-power-bi
Best Regards,
Lin
hi, @Deb3107
You could get it by using the Sort by Column button in power bi desktop, for more detail see below:
https://radacad.com/sort-by-column-in-power-bi
Best Regards,
Lin
I don't appear to have the options when clicking on the 3 dots to revert back to default sort order so I get an error saying "this ccolumn can't be sorted by a column that is sorted,directly or indirectly, another column".
The table I'm trying to sort is a Summary table created by using the SUMMARIZE funtion so I can't use the Query editor either that is suggested here https://community.powerbi.com/t5/Desktop/Sort-by-another-column-error/td-p/61341
I'm at a bit of a loss of what to do now and reports need to go live this week.
hi, @Deb3107
Add a conditional calculate column by dax in Summary table
For example:
For sort=IF([Trading Status] ="Pre-Start",1
IF([Trading Status] ="Established 1-3 years",2
IF([Trading Status] ="Established 3-10 years",3
IF([Trading Status] ="Established >10 years",4))))
...
If there is other attribute, keep the same logic in the formula
Then use selected [Trading Status] filed in the right fields pane->Click Sort by Column->choose the new column.
https://radacad.com/sort-by-column-in-power-bi
Best Regards,
Lin
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 |
---|---|
110 | |
97 | |
78 | |
63 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |