Forum Discussion
Dynamic Slicers or Filters
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.
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.
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,
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.