Hide Slicer Content based on Field parameter Selection

[lherbert501]

Hi,

Could anybody advise if in the attached there is any way I can hide slicer 1, but only when Period is selected in Slicer 2?

I'm thinking you could possibly whiten the font, but didn't know if there was another way? I don't think bookmarks would work as I need the functionality of the slicer to work as a field parameter.

Dummy Data slicer.pbix

[amitchandak · Accepted solution]

@lherbert501 , You can use a measure and use that in slicer to 2 reduce the value and change the color to #FFFFFF00 

Remove slicer 

if(isfiltered(Slicer1[Column]), 1, 0) 

Check in slicer 2 the above measure is 1 

Also, use this measure for color 

if(isfiltered(Slicer1[Column]), "#FFFFFF00", "#000000") 

Also refer 
https://exceleratorbi.com.au/show-or-hide-a-power-bi-visual-based-on-selection/

[amitchandak · Accepted solution]

@lherbert501 , You can use a measure and use that in slicer to 2 reduce the value and change the color to #FFFFFF00 

Remove slicer 

if(isfiltered(Slicer1[Column]), 1, 0) 

Check in slicer 2 the above measure is 1 

Also, use this measure for color 

if(isfiltered(Slicer1[Column]), "#FFFFFF00", "#000000") 

Also refer 
https://exceleratorbi.com.au/show-or-hide-a-power-bi-visual-based-on-selection/

[lherbert501]

Hi @amitchandak ,

I have just tried it properly and the method of hiding seems to work for a table or matrix, but when you do it against a slicer it doesnt seem to hide? It carries the latest value over on its own

I've attached an example

Dummy Data slicer (1).pbix

[v-hjannapu · Accepted solution]

Hi @lherbert501,
Thank you for posting your query in Microsoft Fabric Community Forum. Also, thanks to @amitchandak  for those inputs on this thread. 

Please review the Below thread, as it may provide information to help resolve your issue.
 Solved: Hide/Unhide Slicer based on another slicer values - Microsoft Fabric Community

Hope this helps if you have any queries we are  happy to assist you further.
Regards,
Community Support Team.

[lherbert501]

Thankyou @amitchandak  this is very helpful