Forum Discussion

chethan's avatar
chethan
Icon for Resolver III rankResolver III
9 years ago

stacked column chart not overlay

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

General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests

3 Replies

    • v-huizhn-msft's avatar
      v-huizhn-msft
      Icon for Microsoft Employee rankMicrosoft Employee
      9 years ago

      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

    • v-huizhn-msft's avatar
      v-huizhn-msft
      Icon for Microsoft Employee rankMicrosoft Employee
      9 years ago

      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