Forum Discussion

swain's avatar
swain
Frequent Visitor
8 years ago
Solved

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

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 selec...
  • v-piga-msft's avatar
    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