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,
Have the following issue.
We have a large matrix with % measure with value for each week column and plant name in the rows.
When look to try and sort in descending week order the availabel columns to sort on don't show week.
Also even when go to modelling and explitctly put sort descedning on the week column when put week in a visual like matrxi it is sorting in ascending order.
We wish to sort in descedning order as when users try and send the power bi doc to pdf or powerpoint to print they don't see all the weeks as these are scrollabel due to sheer amount of data.
Please see screenshots below.
week below going horizontally.
Any thoughts on how best to resolve to show weeks in most recent order horizontally?
Thanks
Solved! Go to Solution.
A true feature to sort horizontally is missing, but there is a valid workaround - a bit spartan though..
1. Create a new calculated column where you switch your rows to an alphabetic or numeric sorted equivalent.
Order = SWITCH(Table1[Week], 52, 1, 51, 2, 50, 3.. etc)
2. Follow this:
A true feature to sort horizontally is missing, but there is a valid workaround - a bit spartan though..
1. Create a new calculated column where you switch your rows to an alphabetic or numeric sorted equivalent.
Order = SWITCH(Table1[Week], 52, 1, 51, 2, 50, 3.. etc)
2. Follow this:
Thanks for suggestion.
Tried this and realised had to sort the week column by the other column rather than place a direct sort on the column and now looks to work as expected.
I would have hoped explitly going into modelling to sort the week in descending order for the column directly would have meant anytime column was used in a visual would display it in descending week order but doesn't.
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 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |