Hello, I have a stacked column chart that should show the regional allocation of sales for current year and previous year. I have two value series or measues. The first one is current year sales and the second one previous year sales. How can I get two separate bars for CY and PY side by side? I only get one bar with Region 1 - CY, Region 1 - PY etc. Thanks

Hi There Did you bring your year column inside the dataset if yes just try to place that inside category group Many Thanks Syed Qazafi Anjum Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful.

Hi, there is no year column. That would be easy! I have two measues. One is current year sales and the second one previous year sales.

Hi There Right click on one of your series and go to the properties and go to axis and chart area and try to change it to vertical secondary axis and see this is what you after If you have any questions please do ask. Many Thanks Syed Qazafi Anjum