Disappearing Visualizations

[DuaneFish]

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 "Custom" is chosen from the Date Range Filter:

So i would like this "Custom Date Range" Visualization to not be visible, unless the selection "Custom" is chosen:

I have tried the trick of using a Measure with "#FFFFFF00" to try and make a "Card" Transparent but this doesnt seem to work anymore, not sure if that was an older Trick:

Instead of going transparent it just prints the Hex code.

Here is a good article that also talks about another solution that doesnt work to make the "visual" Dissapear here as well because the "Background" visual is always there... so even if i put a card on top of it using this method the background visual still shows:

https://powerbidocs.com/2020/11/25/displaying-a-text-message-when-no-data-exist-in-power-bi-visual/

Looking to see if there is "No Solution" that works in the current version of PowerBi or if i just missed something. Thanks in advance!

[DuaneFish]

Thank you for the reply. As you mentioned this partly does the trick, but we have to be able to select the actual date values from the custom date range.

I am interested in how the "Color" measure is applied to the "Measure" when it doesnt seem to be referenced or linked in anyway. How is the "Color" measure changing the color of the card for "Measure"?

[DuaneFish]

Oh actually i see you added Conditional Formatting to the "Measure" card referencing the "Color" Measure. Thanks.

[v-yanjiang-msft]

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.