Forum Discussion
Dynamic double Top 10
Anonymous
Hi, i'm not sure if this what you need.
Use a Slicer to Regions
Use the New Table Visual to show the Top 10 Product Group
Use a Table to show the top 10 Products of the selected Group.
Microsoft EmployeeHi, Anonymous
A measure can’t be used in a slicer. And it seems that the contents of a slicer can’t be changed dynamically. Maybe you can try to create two measures and a slicer. Then you can use filter to get the top N. You can have a try.
RankByProductGroup =
CALCULATE (
RANKX ( ALL ( Table1[Product group] ), CALCULATE ( SUM ( Table1[sale 2017] ) ) ),
ALLEXCEPT ( Table1, Table1[Region], Table1[Product group] )
)
RankByProduct =
RANKX ( ALL ( Table1[product] ), CALCULATE ( SUM ( Table1[sale 2017] ) ) )
Thank you for your reply
I think i was not clear enough on what I am looking for. I dont need to display the ranking. I just want to uste the ranking as a filter/slicer to display the sale per product
so the table should look like this
product units sold
a 12
b 13
when the region slicer would be germany a product gruou slicer will be sport. As my data set is much larger than this test data i will only show the top 10 products within the top 10 product groups for all regions...
- Vvelarde
Community Champion
Anonymous
Hi, i'm not sure if this what you need.
Use a Slicer to Regions
Use the New Table Visual to show the Top 10 Product Group
Use a Table to show the top 10 Products of the selected Group.
hi Vvelarde
This is exactly what i need just would like to have it in slicer, instead of new table so i can put it horizontal slicer on top of the dashboard.
I would say it is alternative solution and i will try it out
thank you
- Vvelarde
Anonymous
You can have a better look with a tree Map.