Slicer with dynamic amount of columns using another slicer

[dgonda]

Hi all,

I need to have a slicer with different related columns in it, for example, a row would look like this:
3 - 11188634 - Sweden - Europe - EUR
Now the catch is I need to have these columns customizable so that for example they could remove the currency column.

Since I couldn't figure out how to do it with the base slicer, I figured I should do a custom slicer visual for it, but I'm honestly stuck with how to start it, or even if this is possible. Any help would be appreciated!

[lbendlin · Accepted solution]

@dgonda There are some custom slicer visuals that can do this.  Personally I would rather enable the "Personalize Visual" option in your report and then train your users on the use of that option and the use of the filter pane. Much less work for you and much more flexibility for the users.

[Anonymous · Accepted solution]

HI @dgonda,

Perhaps you can take a look at the following link about dynamic attribute report based on slicer:

Dynamic Attributes In A Power BI Report | P3 Adaptive

Regards,

Xiaoxin Sheng

[lbendlin · Accepted solution]

@dgonda There are some custom slicer visuals that can do this.  Personally I would rather enable the "Personalize Visual" option in your report and then train your users on the use of that option and the use of the filter pane. Much less work for you and much more flexibility for the users.