Forum Discussion
Using Filter in field Parameters Value
Hi P0werBIn00b ,
Could you try below measure and apply it to your table?
If it's not working, please let us know more about the visual which you want to hide.
Selected2 = IF( CALCULATE(ISFILTERED('Table'[Sub Product]),ALLSELECTED('Table')) || CALCULATE(ISFILTERED('Table'[Product]) ,ALLSELECTED('Table')) || CALCULATE(ISFILTERED('Table'[Country]),ALLSELECTED('Table')), 1 , 0)
Hi P0werBIn00b ,
1. Please create a new shape on the visual you want to hide when the slicer is unselected.
2. Create below measure to define the visibility
*Change 'Table' to your TableName
Selected =
IF( ISFILTERED('Table'[Sub Product]) || ISFILTERED('Table'[Product]) || ISFILTERED('Table'[Country]), "#FFFFFF00" , "White")3. Appy this measure to the color fx of your shape
So it should be invisible when the slicer is unselected as below.
Hello isjoycewang ,
I get what you are saying, but I wouldn't be able to click on anything on my visual, would I?
Hi P0werBIn00b ,
Could you try below measure and apply it to your table?
If it's not working, please let us know more about the visual which you want to hide.
Selected2 = IF( CALCULATE(ISFILTERED('Table'[Sub Product]),ALLSELECTED('Table')) || CALCULATE(ISFILTERED('Table'[Product]) ,ALLSELECTED('Table')) || CALCULATE(ISFILTERED('Table'[Country]),ALLSELECTED('Table')), 1 , 0)Thank you isjoycewang,
Worked like a charm,
But could you explain why my previous code didn't work and this did??
Hi P0werBIn00b,
Since you're using this code in a table visual, the context inside the table should be considered as well.
More info about removing context filter, please refer to ALLSELECT function:
https://learn.microsoft.com/en-us/dax/allselected-function-dax