Forum Discussion

WhaleWatcher222's avatar
WhaleWatcher222
Helper II
1 year ago
Solved

Gauge Visual - Custom Label under Callout VAlues

Hi Experts

 

I was hope that adding the following DAX under the Custom Label under Callout Values for a Gauge Visual would show "N/A" when the cell was blank for that KPI

 

5.2 Blanks = 
VAR Avalue = FORMAT(AVERAGE([5.2]),"0%")
RETURN
    IF(ISBLANK(Avalue),"N/A",Avalue)

 in this case if KPI 5.2 was left blank - i want to see "N/A".

 

 

Need Help

2 Replies

  • BhavinVyas3003's avatar
    BhavinVyas3003
    Super User
    1 year ago

    Hi,

    Gauge Visual is designed to display numeric values because it relies on a minimum, maximum, and target range, which all require numerical data.

    If you must use a Gauge, modify the measure to return 0 instead of "N/A".

    If you want "N/A" to be visible, use a Card Visual instead.

    Thanks,

    Bhavin