Show not applicable instead of blank visual

[Chainfire74]

Hi,

When a visual has no data to show after using a slicer, I want the visual to show the words "Not Applicable" rather than just a blank visual. Below is the code I currently use, how would I adapt it to show the words "Not Applicable" when no data?

MT % =

CALCULATE(

    COUNT(MT[Competency Meets Requirement])

    ,'MT'[Competency Meets Requirement] = "Meets Requirement"

)

/

COUNT(MT[Competency Meets Requirement])

Thanks

[jdbuchanan71]

@Chainfire74 

Try something like this.

MT % =
VAR _Result =
    CALCULATE (
        COUNT ( MT[Competency Meets Requirement] ),
        'MT'[Competency Meets Requirement] = "Meets Requirement"
    )
        / COUNT ( MT[Competency Meets Requirement] )
RETURN
    IF ( ISBLANK ( _result ), "Not Applicable", _Result )

[Chainfire74]

Thanks for the reply, I've tried this code but still get 'Blank' rather than not applicable. Any ideas?

Thanks

[v-easonf-msft]

Hi, @Chainfire74 

Currently, gauge graph does not support showing not applicable instead of blank visual.

Best Regards,
Community Support Team _ Eason