Scatter plot with multiple metric ?

[akj2784]

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	B2	92	93
B	B3	94	93

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

Product	Avg at Product Level	Avg at Category level
A1	93	94
A2	95	94
A3	92	94

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 

[v-juanli-msft]

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]

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]

@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]

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.