PowerBI Matrix Visual sorting

by Snora   Last Updated May 15, 2019 17:26 PM

I created a Matrix visualization.

Rows: item number

Columns: year-month

Values: Stock value, an stock value2

How can I sort the stock value2? The Little triangle is not there to do it.

Once i remove the month columns i can sort them but it is not the solution what im looking for. I want to show the top 0-20

Tags : powerbi

Answers 1

In a Matrix Vis you cannot sort on the column (in your case year-month), this has all to do with the fact that this is dynamic created. When you change your row values of year-month, you have more or less columns. For this reason it is not possible to select the column for sorting.

May 15, 2019 17:25 PM

Related Questions

Power BI Embedded Incremental Refresh

Updated February 10, 2019 18:26 PM

How to have GIF image with action in Power BI?

Updated August 23, 2019 07:26 AM