I have a table which is looking something like this:
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?
Go to 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
Now you just need to use the year on the legend.
Proud to be a Super User!
View solution in original post
Thank you very much, this worked to solve my problem!
Check out the News & Announcements to learn more.
Congratulations, the new Super User Season 2 for 2021 has started!
Check out the new Power Platform Community Connections gallery!