Remove "(BLANK)" values

[JKTUATH]

Hello :),

Im currently trying to track KPIs within a gauge visual.

The gauge visual is interacting with a slicer that  also interacts with another gauge.

The issue im having is that when I select an option from the slicer it interacts with the other gauge and does not load any values with the other ( which is how it supposed to function).

But it leaves me with the ugly "(BLANK)" text which I want to remove.

I have tried multiple measurred columns to apply to the visual but with no luck.

Any ideas where my logic is flawed ??

My measures : 

• R_blank = IF(ISFILTERED(Table1[Priority]), "", "No priority set")
• R_blank = IF(HASONEVALUE(work_order_summary_27_Sep_2022[Priority]), "TRUE", "FALSE")

Please & thank you in advance

[vanessafvg · Accepted solution]

then you will need to use a different visual, you are not seeing those values because they are text and a radial gauge visual does not accept text values, it only aggregates them and if there is nothing to aggregate it is either 0, or blank.

[vanessafvg]

What are you expecting instead of the blank value?  The guage expects a numerical value, do you want it to show text instead? or 0?

[JKTUATH]

Yes I want to display the text "Priority not selected or no values to display. Same with urgent & Routine.

[vanessafvg · Accepted solution]

then you will need to use a different visual, you are not seeing those values because they are text and a radial gauge visual does not accept text values, it only aggregates them and if there is nothing to aggregate it is either 0, or blank.

[JKTUATH]

Ok thank you , are there any visuals recommend?.

i would like to merge the both together to correspond with my slicer. 

[v-easonf-msft · Accepted solution]

Hi， @JKTUATH 

There are no similar gauge-type visuals in Micrsoft AppSource.

As a workaround, you might consider creating a card to overlay your current gauge.

Card measure:

Text = IF(ISFILTERED(Table1[Priority]),[Your measure], "No priority set")

Please refer to the following tutorial for more details.

Showing an alternate text when no data available in a Power BI chart visuals 

Group visuals in Power BI Desktop reports 

Best Regards,
Community Support Team _ Eason

[JKTUATH]

Hello @v-easonf-msft,

That's not a bad idea.

Will PowerBi allow me to send the card backward and forward when I have this criteria?

[v-easonf-msft]

Hi, @JKTUATH 

No. The card should be placed in front of the gauge visual.

You may need to adjust the card appropriately to make sure it is only used to cover the text portion "(BLANK)" on the gauge.

Best Regards,
Community Support Team _ Eason