Card that defaults to a value until a slicer selection is made

[ahumke]

I've got a bar chart showing total credits from 2014-2023 across the X axis.  I want to have a card defaults to the total credits from 2018 unless the user clicks on the chart to specify a different year in the trend. Is that possible?

[v-lili6-msft · Accepted solution]

hi, @ahumke

You could use ISFILTERED to create a measure like this

Measure = IF(ISFILTERED('Table'[Year]),CALCULATE(SUM('Table'[Qty])),CALCULATE(SUM('Table'[Qty]),'Table'[Year]=2018))

Then drag this measure into card visual

Result:

If don't select any value, only show 2018 valueafter select one value from slicerafter select one or more values from slicer

Best Regards,

Lin

[ahumke]

Awesome!  Thanks that totally works!

[Anonymous]

It's possible using DAX, you need to create the measure using the function ISFILTERED, this function returns True or False, with this yo can use an IF to decide what calculation the measure will show.

I hope this help you.