Forum Discussion
Scatter plot - Comparison of values from same column
Hi,
I am trying to acheive a scatter plot where i should be able to acheive a comparison between two companies. Company values come from the same column. Also i need to show an additional metric of Industry avg. Is this acheivable in Power BI.
C1 and C2 are company value slices used to compare between any two combinations. Industry avg is a measure which should be shown along with the companies being compared. X and Y axis are built on company visits and Score.
Any kind of help is greatly appreciated. Thank you.
Regards
9 Replies
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882
Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.Hi auppala ,
Still not certain about what did c1 and c2 represent, I understood it as the company value temporarily.
To show the value and average in the scatter plot chart at the same time, you can create an average line without using measure in Analytics pane:
If you think it not help, could you please share more details about this issue for further discussion?
Best Regards,
Yingjie LiIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.
