Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
JemmaD
Resolver II
Resolver II

Create a custom line in a scatter chart

I have a scatter chart showing incoming money vs outgoing money split by location. So each dot is a location, the x axis is incoming money, and y axis is outgoing money.

I want a line in the graph where incoming = outgoings (so where the line meets the axis lines, the axis values are the same e.g. Y axis = 10M X axis = 10M. 

How do I do this?

1 ACCEPTED SOLUTION
JemmaD
Resolver II
Resolver II

I found a solution using Symmetry Shading. This creates a shaded triangle where the values meet, and I changed the bottom half to green (for good) and the top half to red. Perfect.

 

JemmaD_0-1656947163109.png

 

View solution in original post

4 REPLIES 4
JemmaD
Resolver II
Resolver II

I found a solution using Symmetry Shading. This creates a shaded triangle where the values meet, and I changed the bottom half to green (for good) and the top half to red. Perfect.

 

JemmaD_0-1656947163109.png

 

technolog
Super User
Super User

You can try to create a new separate visual and place it on top.

amitchandak
Super User
Super User

@JemmaD , I doubt you can create such a line on the scatter visual. For that you need one categorical axis

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

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

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.