Forum Discussion
Scatter plot - Comparison of values from same column
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
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 |
Hi auppala ,
Maybe like this?
The size of circle represents the Avg value, the color of circle represents the competitors.
Best Regards,
Yingjie LiIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.
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
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:
Best Regards,
Yingjie LiIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.