Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
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.
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.
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
It might be easier if I give you a sample pbix:
https://drive.google.com/open?id=1gH8K0eMPwlMHqRq2tyOKqBJQDxcQ1sqr
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
86 | |
85 | |
84 | |
67 | |
49 |
User | Count |
---|---|
131 | |
111 | |
97 | |
71 | |
67 |