cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
MrBIn
Regular Visitor

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

I have a table which is looking something like this:

 

DescriptionBegin Date2021202220232024
Project 113.06.2021400.000€450.000€450.000€

0€

Project 201.01.20220€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:

Excel.png --> 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):

power bi.png

 

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:

setup.png

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?

 

1 ACCEPTED SOLUTION
MFelix
Super User
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.


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



View solution in original post

2 REPLIES 2
MFelix
Super User
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.


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



View solution in original post

MrBIn
Regular Visitor

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

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!