Automatic Selection in Slicer ?

[F_Reh]

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

[danextian]

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]

Different codes will be default for different pages/reports. 

[pratyashasamal]

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]

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

[pratyashasamal · Accepted solution]

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

[dmcgurn1]

Thank you! @pratyashasamal, forced selection in Chiclet slicer worked for me trying to automatically select an option in a slicer using another slicer!

[F_Reh]

Yes - that is a possible satisfactory solution to my question - to select all the default options then saving the file. I thought there might be a simpler and more practical solution than manually selecting each of the 38 DEFAULT codes in the Slicer list.

The Chiclet Slicer is not suitable solution because I have 88 possible (TOTAL) codes to display (in the Slicer).

[pratyashasamal]

Hi @F_Reh ,
Happy to help you .
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