Display data on a Scatter Plot only if one value of a slicer is selected

[PbiGlobal]

Hi All,

 I am using Scatter Plot and I want to display the data only if one unit is selected and the data should be blank for multiple selections of the slicer.

I have the Unit as a slicer

Below is my Scatter Plot:

I dont know how to link the scatter plot in the below formula:

Measure 4 = IF( HASONEFILTER( 'Sheet2 (2)'[UNIT] ),[Average of Import average per UNIT],BLANK())

Thanks in Advance!!

[vanessafvg]

@PbiGlobal  why do you not just use the measure you have created? instead of the measure you are using?

[PbiGlobal]

Are you talking about the slicer?
@vanessafvg 

[vanessafvg]

@PbiGlobal  no im talking about replace the measure you have with the one you created.  But i could have it wrong.  if you want to share you file with me it might be easier.

[PbiGlobal · Accepted solution]

@vanessafvg I was able to display the data on Sactter Plot when user is selecting single value of a slicer:

SlicerSelection = IF( HASONEFILTER('Sheet2 (2)'[UNIT]),1,0)

I have used this measure in the visual filter of the scatter plot and it worked!!

Thank you!!