Forum Discussion

akj2784's avatar
akj2784
Post Partisan
8 years ago

Scatter plot with multiple metric ?

Hi All,   I have a data as follows.   Category Product Avg at Product Level Avg at Category level A A1 93 94 A A2 95 94 A A3 92 94 A A4 96 94 B B1 93 93 B ...
Need Help
v-juanli-msft's avatar
v-juanli-msft
Community Support
8 years ago

Hi akj2784,

As you said, Scatter plot does not support multiple metrics, here is a workaround using Combo Chart. For more details, please review the example in this PBIX file.

Best regards

Maggie

  • akj2784's avatar
    akj2784
    Post Partisan
    8 years ago

    Thank you for the reply. The visualization is not that apealing if you compare with the expected result. 

    I do have some alternative but looking for visualization similar to the required screenshot with small circles. Here the red circle represent category avg. 

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      akj2784

      I used your dataset and used the visualization "Line and Clustered Column chart" and was able to create below -

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

      Does this help?

       

      Regards

      • akj2784's avatar
        akj2784
        Post Partisan
        8 years ago

        I meant to say I was able to create different vaisualization  usig Line and Clusterd column chart as I showed in the screenshot.

        However I need  something similar to the screenshot in my first message which has scatter plot.