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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
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
Sept PBI Carousel

Power BI Monthly Update - September 2024

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

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Sept NL Carousel

Fabric Community Update - September 2024

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

Top Kudoed Authors