Forum Discussion

Janoshz's avatar
Janoshz
Frequent Visitor
3 years ago
Solved

100% stacked column year comparison

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..

Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    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

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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