Show custom value on card visualization when nothing is selected in slicer

[swain]

Hello,

I've got a card visualization and using different slicers to display different values on the card.

Would it be somehow possible to display a custom value on the card when nothing is selected from slicer? 

It also would help if it would display (Blank) when nothing is selected.

I've looked around, but there seems to be no explanation on this with card visual.

Also any workarounds are welcome (dummy filtering, hiding visual somehow if nothing is selected, etc.)

Thanks in advance!!!

[v-piga-msft · Accepted solution]

Hi @swain,

---

I've got a card visualization and using different slicers to display different values on the card.

Would it be somehow possible to display a custom value on the card when nothing is selected from slicer? 

It also would help if it would display (Blank) when nothing is selected.

---

You could create a measure to get this.

For example, you could create the measure below to get that when you select the value in slicer, the card visual will show the value. Otherwise, the card visual will show Blank().

Measure =
IF (
    ISFILTERED ( O365LicenseReport[order_type] ),
    MAX ( 'O365LicenseReport'[order_type] ),
    BLANK ()
)

Best Regards,

Cherry

[swain]

I finally got it working. 

At first it didn't work for me, but it turned out that I had some hidden filters already on. Now that I got the relationships cleared, everything works as it should!

Thank You @v-piga-msft