100% stacked column year comparison

[Janoshz]

Hello,

How can I compare year by year with slicers using 100% stacked column chart? 

Years should show beside each other in the 100% visual. Ie. I choose from the slicer years 2021 and 2022 and they would show side by side.

Thanks..

[v-cgao-msft · Accepted solution]

Hi @Janoshz ,

You need to create a calendar table and connect it to the fact table.

Create year slicer.

Create a 100% stacked bar chart, note that please change the type of the x-axis from continuous to category.

Result:

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

[negi007]

@Janoshz You can create a visual like below