Forum Discussion
Scatter plot - Comparison of values from same column
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.
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