Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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?
Solved! 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
https://www.youtube.com/watch?v=GINbx-gOwNE
Now you just need to use the year on the legend.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @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
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsThank you very much, this worked to solve my problem!
User | Count |
---|---|
128 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |