Creating a simple bar chart with multiple columns on the x-axis

[MrBIn]

I have a table which is looking something like this:

Description	Begin Date	2021	2022	2023	2024
Project 1	13.06.2021	400.000€	450.000€	450.000€	0€
Project 2	01.01.2022	0€	300.000€	200.000€	200.000€

Based on this table, I want to have a similar chart to the one I was able to put together in Excel in seconds, looking like this:

 --> For every year column, the values from the different rows should be summed up.

However, the best I can do in Power BI is this, using a grouped column chart (ignore the values, the sums are correct):

As you can see, the different columns are "sticking" together and there is no separation by years compared to the excel example.

This is how I set it up:

I also played around a bit and put the different column fields into "axis" for example, but this didn't work.

Am I missing something? How am I able to achieve this, in my opinion relatively simple chart, using Power BI?

[MFelix · Accepted solution]

Hi @MrBIn ,

This is not the best format for the data you need to go to the query editor select the columns of the years and then Unpivot columns

https://www.youtube.com/watch?v=GINbx-gOwNE

Now you just need to use the year on the legend.

[MrBIn]

Thank you very much, this worked to solve my problem!