Scatter Plot

[Kishore_Sr4]

Hello,

 Here I have pasted the Excel Scatter Plot 

Similarly can i Create the same kind of visual in Power BI with average of two different fiels in X-axis,

I tried creating this but getting this error

Is there any other way or any plot to achieve same as the Excel one I pasted!!

Any Suggestions on this

Thanks in Advance!!!

[RayWu]

@Kishore_Sr4 According to the error, you need to set "don't summarise" for X . If it doesn't work then create a new index column, and drag it to the value. Both ways work.

[Pragati11]

Hi @Kishore_Sr4 ,

I would need more details on what you are trying to achieve in Power BI:

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

You can definitely create a scatter chart in Power BI. Something shown below:

[Kishore_Sr4]

Hi @Pragati11 

I am trying to achieve what I have in my Excel plot, that is average value of two different fields has to be shown in same axis

In Power BI I have tried to put two different fields in X-axis but it is arriving at one single Marker point since I want to differentiate two different values

[Pragati11]

HI @Kishore_Sr4 ,

Can you share some sample data here so I can try at my end?