Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

Covering a what-if parameter based on slicer selection?

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.

 

Capture.JPG

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!

1 REPLY 1
Pragati11
Super User
Super User

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

 

 

Best Regards,

Pragati Jain


MVP logo


LinkedIn | Twitter | Blog YouTube 

Did I answer your question? Mark my post as a solution! This will help others on the forum!

Appreciate your Kudos!!

Proud to be a Super User!!

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.