Dynamic Slicers or Filters

[Vin57]

Hello,

I have got nearly 85 filters or slicers in power bi to contorl a table placed below to it (To show values based on the filters or slicers).

It is tedious to place all the 85 slicers at once inside in single page. Also, at any point of time, max of 8 filters only will give a combination and others filters will be blank and it makes sense to show only the 8 filters inside the page based on any first selected value inside a filter.

So, I am looking for all the blank filters to hide based on the any selected value in a filter and other filters supposed to move to next each other for ease visulaization. Is this possible or any visulalization already available to do this or any work arounds to acheive this?

Thanks in Advance!

[MFelix]

Hi @Vin57 ,

First of all, and don't get this in the bad way if you have 85 slicers or filters for a user to get some information then you need to rethink the page or modelling you are doing giving users so many options will make them lose in the middle of the selections and whats is the final result presenting so I would rethink the usage of this page and of the filters/slicers.

Going to the problem at hand one option that I see that can help you reducing the number of filters based on some context can be the Field Parameters, where you would place all the columns you need and that would create a dynamic option for the user to select the slicing and dicing on top of it, but again you need to setup some work arounds with some rankings or categorizations so would be easier for the user to have correct selections.

https://learn.microsoft.com/en-us/power-bi/create-reports/power-bi-field-parameters

Another option can be to do the the customize visualizations option that will allow user to change a specific visual or visuals to add more columns change the type etc.

https://learn.microsoft.com/en-us/power-bi/visuals/power-bi-report-visualizations

Hope this helps you to achieve what you need if you need any more guidance please let me know.

[Vin57]

Hi @MFelix ,

Thanks for your response. To add more clarity on the number of slicers, for example,

- A Company offers products with 85 options to configure a product to sell. But not all 85 options will be configured into an Product at once.

- Only, Max of 10 Options would be used in a product at any given point of time. 

- So, based on a selection from the First filter, out of 85, only 9 applicable filters to be visible and needs to arranged next to each other, so the user would choose the next 9 filters easily and see the products been sold (Like filters 1, 4, 8, 16, 32, 64, 78, 83, 85 been arranged next to each other and other filters were hidden)

- Again, based on another selection from the First filter, out of 85, other 9 combination of applicable filters needs to be visible and placed next to each other. (Like filter 1, 3, 5, 20, 25, 38, 42, 73, 81)

- Since the combinations are so many any use of Bookmark also will be impossible I guess!

Thanks,

[MFelix · Accepted solution]

Hi @Vin57 ,

My question is are those Specific setup predefined? So if I select  1, 4, 8, 16, 32, 64, 78, 83, 85 this would be a specific configuration and the other one (1, 3, 5, 20, 25, 38, 42, 73, 81) would be another configuration.

What you can do is add a field parameter and to that field parameter some columns to be order and sorted, also you would need to have a blank column to use to get the additional filter blaked out.

On the example below I only have 3 values of filter one with 2 columns (Company, Product) and the other with just year, has you can see when I select Cat 1 I see the 2 slicers and when I select cat 2 I see only one slicer:

This has a dynamic way of selecting the data is this something that would work?

On the bottom images you can see that the Cat2 Blank is the column corresponding to the blank column, We need to setup the parameter table so that we have the exact same number of rows for each category otherwise the slicers won't be correctly filled.

I also use an additional column thats sorts each column to position it on the slicer.

This is then used on each slicer:

If you want I can try and setup an example with more filters to simulated a more complex setting and send you the PBIX file.