Forum Discussion
Remove "(BLANK)" values
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
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.
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
7 Replies
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?
Yes I want to display the text "Priority not selected or no values to display. Same with urgent & Routine.
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.
