Forum Discussion
Show custom value on card visualization when nothing is selected in slicer
- 8 years ago
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
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
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