cancel
Showing results for
Did you mean:

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Helper I

## Scatter Plot with a target line and an average line

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

1 ACCEPTED SOLUTION
Community Support

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.

2 REPLIES 2
Community Support

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.

Super User

@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

Announcements

#### Fabric certifications survey

Certification feedback opportunity for the community.

#### Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

#### Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors