Scatter Plot with a target line and an average line

[dollarvora]

I've a dataset with Month and some values, I also have the target information and also the average information
I was wondering how do I visualize all of this in the format below 

For instance consider the below dataset

value	month
67.42436398	November 1, 2020
68.32667872	October 1, 2020
68.33531963	September 1, 2020
69.05157567	August 1, 2020
69.99631021	July 1, 2020
70.36755373	June 1, 2020
70.58675967	May 1, 2020
70.34220032	April 1, 2020
70.44322918	March 1, 2020
71.29026149	February 1, 2020
71.16770719	January 1, 2020
70.71456397	December 1, 2019

The target could be 70%, now every values above the target would be green, every value thats on the target would be yeelow and those below would be red and the average  line (yellow line) would be constant in my case

I'm having a hard time finding any extenal visuals that can help with this 

Thanks

[v-jingzhang · Accepted solution]

Hi @dollarvora 

You can create a measure for dot color like below. Put Month in X axis and Value in Y axis. Format Data colors by Field value based on below measure. Then add a Y-Axis Constant Line with value 70 and an Average Line for Value. You can change their colors and line styles.

Dot Color = 
VAR thisValue =
    SELECTEDVALUE ( 'Table'[value] )
VAR targetValue = 70
RETURN
    SWITCH (
        TRUE (),
        thisValue > targetValue, "Green",
        thisValue = targetValue, "Yellow",
        thisValue < targetValue, "Red"
    )

Kindly let me know if this helps.
Community Support Team _ Jing Zhang
If this post helps, please consider Accept it as the solution to help other members find it.

[amitchandak]

@dollarvora , You will be able to color, Bu will not able draw excat like. Because power will allow on simple Avg line

I have done 4 color, you can do 2

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

Line in added in this video

https://youtu.be/Q1vPWmfI25o?t=2847