Forum Discussion

F_Reh's avatar
F_Reh
Icon for Post Patron rankPost 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 Grap...
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
danextian's avatar
danextian
Icon for Super User rankSuper 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
Icon for Post Patron rankPost Patron
3 years ago

Different codes will be default for different pages/reports.