Forum Discussion
Slicer
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.
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.
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.
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.
