Julia Shah on 02 Jul 2016 02:26:23
Scatter chart could be a much more powerful decision making tool, if we could show 4 quadrants (with background colors and labels) and axis labels (<- Low - Completeness of vision - High ->).
For example, we can all see that Microsoft is a leader when we look at Gartner Magic Quadrant:
https://powerbi.microsoft.com/en-us/blog/gartner-positions-microsoft-as-a-leader-in-bi-and-analytics-platforms/
- Comments (9)
RE: Ability to show quadrants on scatter chart
Being able to have a red background on a quadrant where things should not be, seems a crucial feature to me! Background images would not work as the scatter is generated dynamically and x-negative quadrants (the ones I would want to paint red) would not appear if there isn't data to go on them.
RE: Ability to show quadrants on scatter chart
This still seems like a relevant important requirement for the standard visual (custom visuals aside). The workaround with the Average lines is rather limited: only avg, only 2 main axis measures, no way to use an extra measure for what-if parameters to define the quadrants...
RE: Ability to show quadrants on scatter chart
Hi Team,
Any Update On this.....
RE: Ability to show quadrants on scatter chart
You can do this by adding a "constant line" for the x & y axis. It worked for me with labels and the drill up and down features
RE: Ability to show quadrants on scatter chart
You can create this easily in a Visio diagram and Visio custom visual for Power BI is now available for preview. To enroll visit http://aka.ms/visio-new
RE: Ability to show quadrants on scatter chart
Hi need to add a measure to the legend of the scatter chart. That is not possible in Power BI.
RE: Ability to show quadrants on scatter chart
Same problem, we have axis shifting a lot and we cant use images. We need shading for quadrants, it just makes it super powerful
RE: Ability to show quadrants on scatter chart
I have the same problem, but the described solution from Ian doesn't work for me. I am using average x and y lines which will change depending on the filters applied. So my quadrants change, hence I cant not use a static image in the background. Other solutions?
RE: Ability to show quadrants on scatter chart
One way is to create and save a background image, e.g. using Visio or Powerpoint, and format the Plot Area to display that. For example, the background image could be named, shaded quadrants for a 2x2 matrix or any other image that fits the story you are trying to tell. Concentric sectors radiating from the origin of the axes (see Forrester Wave examples) or a bullseye are other ones to consider. If you set Image Fit=Fit then it will fit your plot area, but you may want to leave text off the image to avoid it being stretched or compressed - use text boxes on the BI report itself. It may take a few tweaks to get your image how you want it to look but it shouldn't be too much work.