Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi guys
I have a coulumn chart with DRILL mode to drill down by dimension
I also wat to show only top10 values
The issue is that when I drill down, I still want to see the top10 values of the drilled to dimension
For example if the first level is customers and the second level is products
First I see the top10 Customers and when I drill into on of those Customers, I want to see his top10 products
When I filter on Top10 I get a message that only one top N filter can be applied, so I believe that the solution should be with some kind of a dynamic dimension
Any solutions?
Thanks
Solved! Go to Solution.
Please find the updated file
https://drive.google.com/file/d/1ypP38IZqdHAHwewn2xr0C-EbT0HDvmQY/view?usp=sharing
If the post helps please give a thumbs up
If it solves your issue, please accept it as the solution to help the other members find it more quickly.
Tharun
@shlomiwPBI
I believe you are referring to this error
if you want to implement topn at different levels of drill down then you can write a measure and use that measure as a filter in your visual. for ex:
I am attaching the file for your reference.
https://drive.google.com/file/d/1ATPwLCxUNTXfhikmuU6o6kBT0tfk95ej/view?usp=sharing
If the post helps please give a thumbs up
If it solves your issue, please accept it as the solution to help the other members find it more quickly.
Tharun
Thanks Tharun
It seems to wok fine with 2 levels in the hierarchy, can you send the example for 3 or more levels?
i need 4 levels in my hierarchy
Shlomi
Another issue is that in this solution the numbers that I see in the top level are not correct, it shows only the sum of the first top 3 values of the lower level and I don't what the numbers to change
Let's assume that Customer A has a total sales value of 1000 USD
Devided into 4 Products:
Prod 1 = 300 USD
Prod 2 = 300 USD
Prod 3 = 300 USD
Prod 4 = 100 USD
in this soultion I will only see total sales of 900 USD in the upper Customers level which is wrong 😞
The sames goes to the next lower levels I assume
Thanks
Shlomi
Please find the updated file
https://drive.google.com/file/d/1ypP38IZqdHAHwewn2xr0C-EbT0HDvmQY/view?usp=sharing
If the post helps please give a thumbs up
If it solves your issue, please accept it as the solution to help the other members find it more quickly.
Tharun
Hi @shlomiwPBI
This might be what you need. There's a download link the description.
Proud to be a Super User!
Hi @shlomiwPBI
If I understood you correctly, the issue is with top n according to the hierarchy level.
Please refer to the linked vide it should help.
https://www.youtube.com/watch?v=Q_rMQ89ng70
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
User | Count |
---|---|
77 | |
74 | |
63 | |
61 | |
45 |
User | Count |
---|---|
108 | |
103 | |
93 | |
83 | |
64 |