Scatter Plot Chart Help

[cdawidow]

Hi guys, I am trying to recreate this example in power bi in a scatter plot chart.  I have my 2 values for x and y ranked across all my customers but when I include customer name or customer numbers (distinct values) within the details segment of the visual I either get an error message or have only one value displayed which I assume represents an average.  Any ideas how to recreate this?

[v-yingjl · Accepted solution]

Hi @cdawidow ,

Based on my test, if you choose the aggreation type as 'Don't summarize' for x-axis and y-axis and put field in Legend or Details, you may get a error message like this:

If so, try to change the aggreation type into Sum to show it in the Scatter plot chart.

Best Regards,
Yingjie Li

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@cdawidow , Please create a color measure like this and use this with option "field" in conditional formatting

here Margin % is like you NPS

Color Dot =
var _avgDisc = CALCULATE([Discount %],ALL(Retail))
var _avgMargin = CALCULATE([Margin %],ALL(Retail))
return switch(TRUE(),
[Margin %]>_avgMargin && [Discount %] <_avgDisc , "Green",
[Margin %]>_avgMargin && [Discount %] >_avgDisc , "Blue",
[Margin %]<_avgMargin && [Discount %] <_avgDisc , "Yellow",
[Margin %]<_avgMargin && [Discount %] >_avgDisc , "Red", "Black")

https://radacad.com/dax-and-conditional-formatting-better-together-find-the-biggest-and-smallest-num...
https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting#color-by-color-values

[Pragati11]

Hi @cdawidow ,

Try moving your Customer Name to LEGEND section rather than Details section.

Thanks,

Pragati