cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

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
PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors