Forum Discussion

cgc1223's avatar
cgc1223
New Member
5 years ago
Solved

Scatter Plot with Dynamic Measure and Static Data

Hello, I am trying to get a scatter plot with a dynamic measure and static data.    The user provides input to a what if parameter slicer which then calculates a value in a measure. I would then li...
Need Help
  • v-robertq-msft's avatar
    v-robertq-msft
    5 years ago

    Hi, cgc1223 

    According to your description, I can roughly understand your requirement, you want to make the data point displayed with the selection of the measure slicer, right? I think you can try my steps:

    This is my test data:

     

    I created a measure like this:

    Flag =

IF(MAX('Table'[X])=[Parameter Value],1,0)

    Then I created a scatter chart to apply a visual filter like this:

     

    And you can get what you want.

    You can download my test pbix file below

     

    Thank you very much!

     

    Best Regards,

    Community Support Team _Robert Qin

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-robertq-msft's avatar
v-robertq-msft
Community Support
5 years ago

Hi, cgc1223 

According to your description, I can roughly understand your requirement, you want to make the data point displayed with the selection of the measure slicer, right? I think you can try my steps:

This is my test data:

 

I created a measure like this:

Flag =

IF(MAX('Table'[X])=[Parameter Value],1,0)

Then I created a scatter chart to apply a visual filter like this:

 

And you can get what you want.

You can download my test pbix file below

 

Thank you very much!

 

Best Regards,

Community Support Team _Robert Qin

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.