Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hello,
I'm total beginner in Power BI and need a bit of help making a line chart showing running total for three different years. Also sorry for the language barrier, since it's difficult for me to explain the problem.
I have three tables (one for each year). Example:
I have crated a new measure in each of the years and I got it to show correctly but only for one year. And it depends from which table I choose "Month Nr." for x-axis.
DAX example for one of the years:
Any help appreciated. Thanks in advance.
Best regards,
Nik
Solved! Go to Solution.
Hi @mist1337
It seems you need to modify your model.
1. Union your three tables to 1 in PQ.
use this tutorial:
https://learn.microsoft.com/en-us/power-query/append-queries
2. Use a calendar table
Link to tutorial:
3. calculate running total for the year for example in the way which showed here:
https://www.youtube.com/watch?v=WNMwTCtjeZc
And just put your year as a legend on a line graph
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Hi @mist1337
It seems you need to modify your model.
1. Union your three tables to 1 in PQ.
use this tutorial:
https://learn.microsoft.com/en-us/power-query/append-queries
2. Use a calendar table
Link to tutorial:
3. calculate running total for the year for example in the way which showed here:
https://www.youtube.com/watch?v=WNMwTCtjeZc
And just put your year as a legend on a line graph
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly