Scatter plot: Change dot color according to specific interval

[maguiseqb]

Does anyone have any idea how to change the colors of my scatter plot according to a specific interval based on the average value (y axis) while still keeping the frequency of all months? The power bi seems to assume I want to differentiate the months but that's not the case. In tableau I'd just click one button.

[v-deddai1-msft · Accepted solution]

Hi @maguiseqb ,

You can create a measure to color scatter plot:

Would you please show us some sample data?

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

Best Regards,

Dedmon Dai

[amitchandak]

@maguiseqb , I made an attemp based on values in past, refer the blog

https://community.powerbi.com/t5/Community-Blog/Customer-Retention-Part-4-Customers-to-Retain-Segmen...

or video https://youtu.be/Q1vPWmfI25o?t=2797

[maguiseqb]

That's a very good approach however it doesn't seem to work since I can't move Month to details probably because my x axis (year) is type text.