Forum Discussion

DuaneFish's avatar
DuaneFish
Microsoft Employee
3 years ago

Disappearing Visualizations

Hello,   I would like to find a way to make a visual "Dissapear" based on a selection of a filter.  I have these two visualizations and the "Custom Date Range" is only applicable when "...
Need Help
Tips and Tricks
Tutorial Requests
v-yanjiang-msft's avatar
v-yanjiang-msft
Community Support
3 years ago

Hi DuaneFish ,

By my test, it can be achieved partly. Using a card visual on top of the custom date range slicer, create a measure into the card visual:

Measure = ""

Create another measure to color the backgroud color of card visual:

Color =
IF (
    SELECTEDVALUE ( 'Table'[Date Range] ) = "Custom(Monthly)",
    "#FFFFFF00",
    "White"
)

The result is when we select Custom in the slicer, we can't select value in the custom data range slicer as card visual is on top of it.

I attach my sample below for your reference.

 

Best regards,

Community Support Team_yanjiang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.