Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
115 | |
113 | |
105 | |
95 | |
58 |
User | Count |
---|---|
174 | |
147 | |
136 | |
102 | |
82 |