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?
Solved! Go to Solution.
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.
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.
That looks good=) It's not very famous option=)
You can try to create a new separate visual and place it on top.
@JemmaD , I doubt you can create such a line on the scatter visual. For that you need one categorical axis
Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.
Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!
User | Count |
---|---|
209 | |
51 | |
43 | |
41 | |
39 |
User | Count |
---|---|
270 | |
210 | |
73 | |
70 | |
65 |