stacked column chart not overlay

[chethan]

Hello folks,

Am trying to plot 5 measure (not over lay) in stacked column chart with One Value and without Clustered Chat so I can filtering by product

Example:

My Measures = “Total Sales”, “Profit”, “Loss”, “Average Sale”, “Average Profit”.

If I select the Product from the slicer it should have to show all the above measures in one chart with different stacks without overlay by all the measures.

Regards,

Chetan K

[chethan]

Am waiting for suggestion... please help

[v-huizhn-msft]

Hi @chethan,

Have you resolved your issue? IF you have, welcome to share your solution or mark the right reply as answer.

Best Regards,

Angelia

[v-huizhn-msft]

Hi @chethan,

Which field is located in x-axis? When you create a stacked column chart, display the measure in values fields, it will display in different stacks. Please see the following screenshot, select ID as x-axis, the two measure as values. Different stacks show different measures' value by comparing table visual and  stacked column chart.



I am really confusing your requirement: "If I select the Product from the slicer it should have to show all the above measures in one chart with different stacks without overlay by all the measures." Could you please share more details and your sample table for further analysis?

Best Regards,
Angelia