Forum Discussion
Sort all values (numeric) in matrix using DAX
- Question: How to sort all values in matrix using DAX? Goal: pick N highest / lowest values with relevant dimensions. - Description: Matrix Trenddev has 2 dimensions: year (number) and location (nu...
try these two steps
1, put both Locations and Year fields in the row
2, create a measure with RANKX to filter the visual