Forum Discussion

auppala's avatar
auppala
Helper I
6 years ago

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 metri...
Need Help
Show and Tell
v-yingjl's avatar
v-yingjl
Community Support
6 years ago

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's avatar
auppala
Helper I
6 years ago

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's avatar
    v-yingjl
    Community Support
    6 years ago

    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's avatar
      auppala
      Helper I
      6 years ago

      Hi v-yingjl ,

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

       

      Regards