Forum Discussion
bdehning
Post Prodigy
3 years agoTOP N Slicer Default
I created a Top N Slicer with Choices of Top 3, 5, 10, 20 and 25. How do I get default for that page to show all values. Currently, it is defaulting to only show the Top Value for every new us...
- 3 years ago
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
Ashish_Mathur
Super User
2 years agoI still do not understand what yo want but try this measure
Measure = calculate([count],topn(3,all(Data[Occupation]),[Count]),values(Data[Occupation]))
Hope this helps.
bdehning
Post Prodigy
2 years agoI just need a Top N Slicer work to still work with the hierarchhy and be able to select Top 3; Top 5 or Top 10 for example.