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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Ability to hide/unhide visuals using DAX

Due to the way that Power BI functions, I'm not sure if that's possible, but I'll shoot my shot. I'd like to hide and unhide visuals based on what's selected in a slicer, and I'd like to configure that with a measure. Basically, if 'x' it's selected then 1, if 'y' then 0 etc., and use that to hide/unhide a viz. There are workarounds, but in my opinion are quite limited and not ideal, for example using bookmarks or overlapping two vizuals and use conditional formatting on the colours.

Status: New
Comments
kleigh
Responsive Resident
There are a lot of past ideas on this https://community.fabric.microsoft.com/t5/Fabric-Ideas/Visibilty-Hide-an-Item/idi-p/4501757 ... The word is that it's not possible with the current DAX engine due to how it orders queries (the visual would have to do one query to decide if it is visible or not, but then it can't trigger the second query to load the data if it is visible). This also ties in with the measure defaults for slicers: there needs to be some way for the DAX engine to know the correct order so visuals triggering new queries can't produce an infinite loop. It's supposed to be planned and they're looking for a solution, but seems like a bit longer to wait.