Forum Discussion
Interactive Sorting for Power BI Metric Visual
Hi all,
I have a data visulaization in the below format in a Metrix visual.
| Sales Agent | Jan-22 | Feb-22 | Mar-22 |
| A | 10 | 1 | 100 |
| B | 1 | 8 | 65 |
| C | 1 | 5 | 99 |
| D | 0 | 3 | 3 |
| E | 100 | 0 | 267 |
I want to sort the individual columns in Power Bi desktop and service. For example if I click on the Feb-2022 column the matrix should be formatted ascending/ descending based on the numbers.
Could you please let me know if there is an alternative otherthan the paginated reports.
Aju
Hi Anonymous ,
As a workaround, you could pivot the YearMonth column in the Power Query. If your YearMonth column is a calculated column using DAX. You need to create a custom column using M in the Power Query first.
Then you can sort by Feb-22.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 Reply
Hi Anonymous ,
As a workaround, you could pivot the YearMonth column in the Power Query. If your YearMonth column is a calculated column using DAX. You need to create a custom column using M in the Power Query first.
Then you can sort by Feb-22.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.