Matrix Rows with sorting number

[PowerBIOrg]

Dear All,

Is it possible to do something like the following with matrix?

Above table presents Top 5 Type by Group by Year with percentage of changes per year. Sort column is needed.

Thank you. 

[amitchandak]

@PowerBIOrg , FOr TOP 5 we have to use a measure filter using rank. For format, we might have to use Measure - Switch Value on Row.

Measure Rank: https://www.youtube.com/watch?v=DZb_6j6WuZ0&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=40

Calculation Groups can give more formats- Measure Slicer, Measure Header Grouping, Measure to dimension conversion. Complex Table display: https://youtu.be/qMNv67P8Go0

[PowerBIOrg]

Hi, thank you for the answer. I knew that I can get Top 5 with rankx, but how to add that Sort # before the Type? 

[amitchandak · Accepted solution]

@PowerBIOrg , for that you have to rank bucketing

check if this code can help

Dynamic segmentation -Measure to Dimension conversion: https://youtu.be/gzY40NWJpWQ

In case the rank bucket is a bit different, you might need allselected, in the final measures too

Power BI- TOPN with Others- https://youtu.be/I_TY4hVlzAE

[PowerBIOrg]

Hi, is there anyway to show that Total by Year? My Column fields is Group and Year.