Forum Discussion
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 user?
It does change when I make a Top N selection and shows the correct amount.
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
7 Replies
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
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.
How can I tweak the TOPN Slicer to still work if I add other Row values as hidden items? Slicer has no effect now.
Hi,
Share some data to work with, explain the question and show the expected result.
