Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
jlinhenley
Frequent Visitor

Top N and Others in matrix row

There are a lot of posts about top N and others but none of them deal with a matrix.

Currently, this is my matrix using the default "Top N" filter. but I would like to achieve something like the excel picture. All of this needs to change depending on filters. Is this possible? There are many posts about creating a rank measure but I cannot use them in a row or column for a matrix.excel others.pngmatrix others.png

 

 

3 REPLIES 3
JanV
Resolver I
Resolver I

Same issue here.

 

Would like to only show the top N rows in a matrix visual based on a certain value and have all other categories added up to "Other" at the bottom. I've only found posts that create 2 measures and involve bar charts.

v-yulgu-msft
Microsoft Employee
Microsoft Employee

Hi @jlinhenley ,

 

Which value is based on to filter Top N? You said "All of this needs to change depending on filters", do you mean "Top N" is changed dynamically based on slicer selection? Why do you say  cannot use rank in a row or column for a matrix?

 

Best regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

It might be easier if I give you a sample pbix:

 

https://drive.google.com/open?id=1gH8K0eMPwlMHqRq2tyOKqBJQDxcQ1sqr

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.