Show scatter data only when selecting data

[Allav]

Hello,

I am trying to keep my scatter, fever chart empty until something is selected on the left table. I tried using the suggestion found in the forum, to create the measure:

SlicerCheck = =if(calculate(distinctcount([SlicerColumn]),allselected([SlicerColumn]))=1,"Y","N")

but it is not working for me, I add this measure to the visual filter and set to Y and still see all the scatters in the chart. maybe I am puting the wrong [slicer Column]?? not sure..

your help is appreciated!

[v-lili6-msft · Accepted solution]

hi,@Allav

     You can try to use ISFILTERED to add a measure like this:

new SlicerCheck = 
IF(ISFILTERED(VehicleTrend[ReportDate])=BLANK() ,"Please Select a Report Date", BLANK())

and then set visual level filter:

Here is demo , please try it

https://www.dropbox.com/s/8pexfwp0nm9536a/Show%20scatter%20data%20only%20when%20selecting%20data.pbi...

Best Regards,

Lin

[Allav]

Thanks so much, it worked!