Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi all,
I want to Sort my Matrix vizual (like on picture) columns by grand totals.
Is it possible to do this without adding calculated columns?
Thanks a lot Rita
Solved! Go to Solution.
@Ritaf , I doubt there is an option for that. It will happen by default ascending sort or based on sort column. You can create a sort column based on these values, but that would be static.
Hi @Ritaf ,
Currently there is no option about sorting by grand total in matrix visual directly, you can consider create a conditional column in power query editor then sort by this custom column, refer this sample: Sort Matrix by column total and row totals
Also, here is an idea about sorting by row totals in matrix, you can vote for it to help us improve power bi and make this feature coming sooner.
Best Regards,
Yingjie Li
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Ritaf ,
Currently there is no option about sorting by grand total in matrix visual directly, you can consider create a conditional column in power query editor then sort by this custom column, refer this sample: Sort Matrix by column total and row totals
Also, here is an idea about sorting by row totals in matrix, you can vote for it to help us improve power bi and make this feature coming sooner.
Best Regards,
Yingjie Li
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
Thank you very much.
I tried to assitent my collegue whose works in Tabular mode an have an access only for measures creating, i understand that unfortunately there is no way he can do this wothout DBA'S ivolvement .
@Ritaf , I doubt there is an option for that. It will happen by default ascending sort or based on sort column. You can create a sort column based on these values, but that would be static.
User | Count |
---|---|
141 | |
113 | |
104 | |
78 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |