Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
MrBIn
Frequent 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



MrBIn
Frequent Visitor

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

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors