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.
I used 2 measures for running total this year and last year.
RunningTotalLastYear =
calculate( [Cummulative Spend], dateadd(GLTRANS[Posting Date].[Date], -1, year))
but then it does show 2 lines in 2 splited line chart. but I need to have overlapped line chart like below screenshot as of example. Could you help how to creat measures to make line chart for running total this year and last year like below screenshots?
I also tried with below another measures as well, but then it's not working neither.
Hi,
Share the download link of the PBI file.
Hi !
I can't open the link. Could you possibly share again?
Thanks!!
User | Count |
---|---|
118 | |
66 | |
65 | |
56 | |
50 |
User | Count |
---|---|
182 | |
86 | |
67 | |
62 | |
53 |