Forum Discussion
Scatter Plot Chart Help
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?
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 LiIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
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-numbers-in-the-column
https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting#color-by-color-valuesHi 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 LiIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.
