Forum Discussion

Elisa_E's avatar
Elisa_E
Helper I
9 years ago
Solved

Dynamic text based on slicer

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...
Need Help
  • v-chuncz-msft's avatar
    v-chuncz-msft
    9 years ago

    Elisa_E,

     

    You may add a measure for Card visual.

    Measure =
IF (
    ISFILTERED ( Table1[country] ),
    SUM ( Table1[value] ),
    "No data available"
)
v-chuncz-msft's avatar
v-chuncz-msft
Community Support
9 years ago

Elisa_E,

 

You may add a measure for Card visual.

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