Covering a what-if parameter based on slicer selection?

[Anonymous]

Hi there! If I have a series of what-if parameters and a slicer corresponding (in name) to each of these,then how can I "cover up" a certain what-if parameter based on this selection?

Example:

Below, if the slicer is selected as is, I would like the "SD Percent" what-if parameter to disappear. And when another option is selected on the slicer, the "SD Percent" parameter to re-appear.

Idea:

Perhaps this could be done by using a textbox to cover it up with conditional formatting. However, this means that even when this text box would be transparent, it wouldn't be possible to interact with the what-if parameter as the text box would be in front of it. So any ideas would be welcomed!

[Pragati11]

Hi @Anonymous ,

You can try using some kind of Bookmarks which can help in hiding and showing of the visual.

So, in your case you will have 4 Bookmarks/Buttons for your Dependent Variable - IPSC, SD%, PRODUCTION TARGET, USD%.

You can then set-up actions on these bookmarks to hide/show your what-if parameter slicers. Refer following article for the steps to hide/show visuals using bookmarks:

https://community.powerbi.com/t5/Community-Blog/Toggle-Between-Charts-in-Power-BI/ba-p/1345014

Thanks,

Pragati