Forum Discussion
bdehning
3 years agoPost Prodigy
TOP 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
amitchandak
3 years agoSuper User
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
bdehning
3 years agoPost Prodigy
I did get the very high option to work as I made it the default. I will work on your other alternative solution as well.