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 III
Super User III

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 III
Super User III

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.

Get Ready for Power BI Dev Camp

Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.

Get Ready for Power BI Dev Camp

Power BI Dev Camp - September 30th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!

PowerPlatform 768x460.png

Microsoft Learn

Check out our new Discover Your Career Path blog post series and get all the details.

Top Solution Authors