How do I show no data in gauge until slicer is selected

[siddrow]

Hi all

What measure do I need to create to show no data in my gauge visual until I select something from my slicer? I have % in my value and % in my target value and in my slicer I can select the area (department). When I have not selected anything in the slicer, it's just combining all the data from all areas and I do not want this. I don't want to hide the visual all together.

thanks in advance

[v-yalanwu-msft · Accepted solution]

Hi, @siddrow ;

Here is a simple data to show it, You could create another table as slicer and without relationship.

1.create a slicer table.

Slicer = VALUES('Table'[department])

2.then create a measure.

flag1 = IF(ISFILTERED('Slicer'[department]),1)

Then apply it into filter.

3.Or create a measure.

flag2 = 
IF(ISFILTERED('Slicer'[department]),
   CALCULATE(SUM([VALUE]),FILTER('Table',[department] in ALLSELECTED(Slicer[department]))))

The final output is shown below:

   

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@siddrow , You can create a measure with help from isfiltered . If needed use hasonevalue too

if(isfiltered(Table[Department]), [Measure], blank())

https://powerpivotpro.com/2013/03/hasonevalue-vs-isfiltered-vs-hasonefilter/

[siddrow]

Hey!

Thanks for your response. Sorry I am VERY new to measures. When you say [Measure] do I put in the name of the measure I am creating? E.g. I am calling the measure Gauge, so would it look like this?: if(isfiltered(Table[Department]), [Gauge], blank())

What will the measure look like if add in hasonevalue too?