Forum Discussion

bdehning's avatar
bdehning
Post Prodigy
3 years ago
Solved

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...
Need Help
  • amitchandak's avatar
    amitchandak
    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's avatar
Ashish_Mathur
Super User
2 years ago

Hi,

Share some data to work with, explain the question and show the expected result.

bdehning's avatar
bdehning
Post Prodigy
2 years ago

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 $.    

 

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    2 years ago

    I 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's avatar
      bdehning
      Post Prodigy
      2 years ago

      I 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.