Forum Discussion

akj2784's avatar
akj2784
Icon for Post Partisan rankPost 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
Icon for Community Support rankCommunity 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
Icon for Post Partisan rankPost 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
      Icon for Post Partisan rankPost 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.