How to show no data (0%) in gauge until slicer is selected

[giramswa]

What measure do I need to create to show no data in my gauge visual until I select something from my slicer? I have 'Budget' in my value shown as percentage, and in my slicer I can select the Project Number. When I have not selected anything in the slicer, it's just combining all the data from all Projects and show in guage and I do not want this. I don't want to hide the gauge visual instead I want it to show empty (0%) when there is no selction in slicer. How to do this?

[NickolajJessen]

Hi,

Have you looked into using the HASONEVALUE formula?
It Would look something like this:
If(HASONEVALUE([Project Number]), [MyMeasure], 0)

[AlB · Accepted solution]

Hi @giramswa 

Assuming [Budget] is the measure you are currently using in the gauge, you can create another measure that uses [Budget] and place it in the gauge and format it as percentage:

Measure_ =
VAR aux_ = SELECTEDVALUE(Table1[Project Number])
RETURN
IF(NOT ISBLANK(aux_), [Budget], 0)

Please accept the solution when done and consider giving a thumbs up if posts are helpful.  Contact me privately for support with any larger-scale BI needs, tutoring, etc.

[giramswa]

@AlB Thank you so much for the quick help, this is exactly what I was looking for.