Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi guys, I was wondering if there's a way to show top 10 values cascading into the next hierarchy in a matrix table?
I know there is the Top N filter, which works in the first level of the hierarchy. However, when you go to next level of the hierarchy the filter doesn't get applied.
Do you have any suggestions how to get around this?
Thanks,
CUR
Solved! Go to Solution.
Hi @Anonymous,
Here is a blog describing Ranking with Hierarchy Drill-Down for your reference.
Best regards,
Yuliana Gu
Hi @Anonymous,
Here is a blog describing Ranking with Hierarchy Drill-Down for your reference.
Best regards,
Yuliana Gu
Hi There,
I am facing an similar issue where i am trying to find out top 5 values cascading into the next hierarchy in a matrix table.
I have created their rank in a similar way but i am not sure how to get Top 5 values out of that Rank.
Can you please help by telling this after creating Rank what should we do to get Top N values?
Thanks,
Ashish
User | Count |
---|---|
139 | |
113 | |
103 | |
73 | |
63 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |