Forum Discussion
Post ProdigyHide Slicer Content based on Field parameter Selection
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.
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/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.
4 Replies
- amitchandak
Super User
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/
lherbert501Thankyou amitchandak this is very helpful
- 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
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.