Forum Discussion

admin_xlsior's avatar
admin_xlsior
Icon for Post Prodigy rankPost Prodigy
5 years ago
Solved

Dynamic options for chiclet slicer

Hi,   Can we create a dynamic options for a slicer ? I have a need like a switch button which I think nice to use Chiclet slicer, but the options is a predefined options like : View By Country and ...
Tips and Tricks
  • MFelix's avatar
    MFelix
    5 years ago

    Hi admin_xlsior ,

     

    You could always turn the direct query into a composite model that uses direct query and import mode tables.

     

    But keeping the model has you have and since you cannot use measure within slicers I believe that you can male use of buttons to simulate the effect of the selection I can see two different alternatives and you can select the best one for you:

    • Using two buttons and having an effect of sliding with the option selected on the left and rigth
    • Using for buttons and making it similar to a slicer turnnig off an on two at a time

    See both examples below and in attach file.

     

     

MFelix's avatar
MFelix
Icon for Super User rankSuper User
5 years ago

Hi admin_xlsior ,

 

To what I can understand you want to have two visualizations and change the way the calculation is done in this case you can use bookmarks and two different visualizations and no need to have the use of a slicer you can create two buttons and then make connection to the different bookmarks.

 

Check the links below:

https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-bookmarks

admin_xlsior's avatar
admin_xlsior
Icon for Post Prodigy rankPost Prodigy
5 years ago

Hi MFelix ,

 

True, but I need to show which button are in "pressed" condition, this is not supported with button 😅

 

So, the requirement is, all the options are still visible for user to know what are the options available, but also showing which option currently showing. Slicer is a commong and simplest way to show it. Alhtough, chiclet slicer is nicer to have.

 

Thanks.

 

 

 

 

  • MFelix's avatar
    MFelix
    Icon for Super User rankSuper User
    5 years ago

    Hi admin_xlsior ,

     

    You could always turn the direct query into a composite model that uses direct query and import mode tables.

     

    But keeping the model has you have and since you cannot use measure within slicers I believe that you can male use of buttons to simulate the effect of the selection I can see two different alternatives and you can select the best one for you:

    • Using two buttons and having an effect of sliding with the option selected on the left and rigth
    • Using for buttons and making it similar to a slicer turnnig off an on two at a time

    See both examples below and in attach file.