Forum Discussion

F_Reh's avatar
F_Reh
Post Patron
3 years ago
Solved

Automatic Selection in Slicer ?

Hello,

 

I need to place a Slicer on a page/report in my Dashboard, where the field (for this slicer) could be one of possible 88 Codes and these will all displayed in the Slicer. However, the Graph/Chart on the page/report needs to default to showing the Trends of only 38 of the codes (but the User can select other Codes or deselect any of the 38 codes if they choose to) . I do not want change the SQL Query to bring in only 38 codes, because the other codes will be shown in the other Reports/Pages. And I don't want to create multiple subsets from the same Data Source for each Report/page because that will rapidly increase the File Size. I would appreciate if there are any suggestions, of Auto-selecting the relevant 38 codes within the Slicer (whilst still listing all 88 codes for possible selection/deselection) ?

 

Appreciatively

Need Help
  • pratyashasamal's avatar
    pratyashasamal
    3 years ago

    Hi F_Reh ,

    If you have a default selection you want on a slicer, you can make those selections and save the file with those selections made and the slicer will be held in that state until a user changes it. It will always default back to that selection when you reload the page. I'm not sure if that's what you're looking for. The request is a little vague.
     Or You can also this option 

    The Chiclet Slicer - has a Forced Selection option...

    https://app.powerbi.com/visuals/show/ChicletSlicer1448559807354

    Thanks ,
    Pratyasha Samal 
    Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
    If you found this post helpful, please give Kudos C

8 Replies

  • pratyashasamal's avatar
    pratyashasamal
    Memorable Member
    3 years ago

    Hi F_Reh ,
    Can you please share a sample .pbix file , so that i could understand the issue clearly .
    Thanks ,
    Pratyasha Samal
    Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
    If you found this post helpful, please give Kudos C

    • F_Reh's avatar
      F_Reh
      Post Patron
      3 years ago

      Essentially, I only need to know if Default/Auto-selection in Slicers is possible, in light of the large number of selections needed.

      • pratyashasamal's avatar
        pratyashasamal
        Memorable Member
        3 years ago

        Hi F_Reh ,

        If you have a default selection you want on a slicer, you can make those selections and save the file with those selections made and the slicer will be held in that state until a user changes it. It will always default back to that selection when you reload the page. I'm not sure if that's what you're looking for. The request is a little vague.
         Or You can also this option 

        The Chiclet Slicer - has a Forced Selection option...

        https://app.powerbi.com/visuals/show/ChicletSlicer1448559807354

        Thanks ,
        Pratyasha Samal 
        Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
        If you found this post helpful, please give Kudos C
  • danextian's avatar
    danextian
    Super User
    3 years ago

    Hi pratyashasamal,

    How about creating a calculated column to indicate whether a code is in the list of default codes and use that in a slicer? Say, if it is in the list show "default" otherwise "other codes" and "default" is selected by default.

    • F_Reh's avatar
      F_Reh
      Post Patron
      3 years ago

      Different codes will be default for different pages/reports.