Forum Discussion
Creating a simple bar chart with multiple columns on the x-axis
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?
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.
2 Replies
- MFelix
Super User
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.
- MrBInFrequent Visitor
Thank you very much, this worked to solve my problem!