Slicer

[ashutoshgadgil]

We have two slicers, one of which is field parameter containing values like age, race, gender, brand, sub brand. Second slicer is Sub Brand slicer having values for different sub brands. The ask is like, if user selects any Sub Brand value from second slicer, then from field parameter i.e First Slicer should not show Sub Brand as an option for selection. How we can achieve this. Expecting experienced folks to give guidance. Thank you in advance

[ashutoshgadgil]

Thanks for helping out, I will try your approach

[ashutoshgadgil]

Hi @danextian, we implemented it in our file and it is working, however there is some change in requirement we need to make Sub brand slicer as single select with All as a selection which we have implemented. We implemented this by making Sub brand all column and appending existing values once again and input "All" in table front of it, now we want to implement it for this use case. Can you suggest any solution for this? Let me know if any clarification is required.

[ashutoshgadgil]

Thank you for this wonderful explaination.

[danextian · Accepted solution]

Hi @ashutoshgadgil 

Create a measure that check whether Sub Brand isfiltered and if the Parameter Order is equal to that of Sub Brand in the parameters table.

Hide Product =
IF (
    ISFILTERED ( financials[Product] )
        && SELECTEDVALUE ( Parameter[Parameter Order] ) = 3,
    0,
    1
)

Use this measure as a visual filter.

[ashutoshgadgil]

Hi @danextian, we implemented it in our file and it is working, however there is some change in requirement we need to make Sub brand slicer as single select with All as a selection which we have implemented. We implemented this by making Sub brand all column and appending existing values once again and input "All" in table front of it, now we want to implement it for this use case. Can you suggest any solution for this? Let me know if any clarification is required.

[danextian]

So it is true that, with each day, out of this world requirements just appear out of thin air. lol.

You will need to create  a table that has all the products and the word all and connect that to the fact table.

Naturally, All doesn't exist in product column so you will need to create a measure to show the aggregate for all and all the products if all is selected from the slicer.

You will  the need to modify the field parameter visual filter measure.

Please see the attached sample pbix.