Forum Discussion

akj2784's avatar
akj2784
Post Partisan
8 years ago

Scatter plot with multiple metric ?

Hi All,

 

I have a data as follows.

 

CategoryProductAvg at Product LevelAvg at Category level
AA19394
AA29594
AA39294
AA49694
BB19393
BB29293
BB39493

 

I select Category as "A" from the slicer and Product "A1,A2,A3" from the slicer.

I want to see avg of Product A1,A2,A3 and also at the same time I want to see Avg for Category A.

 

So my tabular result should be

 

ProductAvg at Product LevelAvg at Category level
A19394
A29594
A39294

 

Assume I am able to get the tabular report as above, I want to create a visual similar to below. wherein Red is my Category Avg and other 3 circles are for 3 different products A1, A2 and A3. 

Any sugegstion for different visual if this is not feasible.

 

Scatter plot does not support multiple metrics. 

 

Regards 

 

 

Need Help

4 Replies

  • 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