Forum Discussion
Post ProdigyTOP N Slicer Default
bdehning , One way to show is having very high value.
Or have a list where you do not select anything then you can try like
if(selectedvalue(Param[Param]), [Measure], [TOP N Measure])
Learn Power BI: Dynamic TOPN using TOPN/Window and Numeric parameter: https://youtu.be/vm2mdEioQPQ
Super Userbdehning , One way to show is having very high value.
Or have a list where you do not select anything then you can try like
if(selectedvalue(Param[Param]), [Measure], [TOP N Measure])
Learn Power BI: Dynamic TOPN using TOPN/Window and Numeric parameter: https://youtu.be/vm2mdEioQPQ
bdehningI did get the very high option to work as I made it the default. I will work on your other alternative solution as well.
- bdehning
How can I tweak the TOPN Slicer to still work if I add other Row values as hidden items? Slicer has no effect now.
- Ashish_Mathur
Hi,
Share some data to work with, explain the question and show the expected result.
- bdehning
Its hard to share data with my file.
What I have is Occupations with Subcategory being Injury in the Matrix.
I want to be able to use Top N Slicer to select Top 3, 5 or 10 Occupations by Count on One table and by Total Incurred on the other and the subcategory just comes along.
So for example, I select Top 3 on Slicer and on Count Table I should get Care Professional 743, Unknown 144 and Caregiver 50 and on Total Incurred Table I should get Care Professional $, Caregiver $ and Unknown $.
