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