cancel
Showing results for
Did you mean:

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

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
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.

4 REPLIES 4
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.

Super User
Super User

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

Super User

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