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 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,
Super UserHi 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.