Scatter plot - Comparison of values from same column

[auppala]

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

[v-yingjl]

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 Li

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

[auppala]

Hi @v-yingjl 

C1 and C2 are company values which have be shown as two different dropdowns which will enable user to select two different companies for comparison in the scatterplot. 

[v-yingjl]

Hi @auppala ,

Could you please consider sharing a sample .pbix file for further discussion? Please remeber to replace the sensitive information in the file.

Best Regards,

Yingjie Li

[auppala]

Hi @v-yingjl , 

Competitor 1 and Competitor 2 are two dropdown filters which can be used to compare between two companies in the scatter plot. Industry Avg and Account are the constant based on the Parent Company selected. 

 Please find the sample data file and requirement screenshot below. 

 

ParentCompany	Company	Visits	Engagements	Industry Avg
Company1	Comp123	4	10	2.3
Company1	Comp124	5	10	2.3
Company1	Comp125	3	5	2.3
Company1	Comp126	3	6	2.3
Company1	Comp127	2	8	2.3
Company1	Comp128	5	9	2.3
Company1	Comp129	3	5	2.3
Company1	Comp130	4	8	2.3
Company1	Comp131	4	10	2.3

[v-yingjl]

Hi @auppala ,

Maybe like this?

The size of circle represents the Avg value, the color of circle represents the competitors.

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.

[auppala]

ok. Thats great, but can we compare the competitor values using two dropdown filters as shown in the screenshot.

At any given point in time we should be able to see the parentcompany, Industry average and two selected competitors from the dropdown filters. 

Regards

[v-yingjl]

Hi @auppala ,

I'm afraid scatter plot chart could not achieve this. If create slicers, the scatter plot chart will also be affected if the slicer has been changed.

Refer these articles about scatter plot chart:

1. Scatter Chart in Power BI 
2. Storytelling with Power BI Scatter 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.

[auppala]

Hi @v-yingjl ,

    Thank you very much for the inputs. Do you know anyway how we can acheive this scenario in Power BI?

Regards

[Greg_Deckler]

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.