Dynamic text based on slicer

[Elisa_E]

Hi,

I have a dataset with three key columns (country, category, and value). Some countries do not have data in the value column for some categories.

I have certain visuals connected to a country slicer that I would like to display only if there is data, and to have text show up "No data available" when the country selected is empty. Is there a way to do this?

Thanks!

[v-chuncz-msft · Accepted solution]

@Elisa_E,

You may add a measure for Card visual.

Measure =
IF (
    ISFILTERED ( Table1[country] ),
    SUM ( Table1[value] ),
    "No data available"
)