Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi All,
I am trying to show Current year rolling 12 month and Prior year rolling 12 month measures as two lines on the same chart. When I put them in the Line Visual using Month (without Year) on the Axis it starts from Jan as expected and when I use Month&Year I get lines one after another like below. I have seen a similar thread related to this topic but didn't find any solution, Please suggest if there is any work around.
Thanks in advance
Solved! Go to Solution.
Hi @Anonymous ,
What is your measure for Prior year rolling 12 month ?
Based on my research, your measure should achieve below data:
You could also download my pbix file to have a view.
Regards,
Daniel He
Hi @Anonymous ,
Could you please tell me if your problem has been solved? If it is, could you please mark the helpful replies as Answered to close this topic?
Regards,
Daniel He
Hi @v-danhe-msft ,
Sorry for the late response. I see this is marked as solved but I would still like to post my measures which didn't give me what I want:
Rolling 12 Months =
Hi @Anonymous ,
What is your measure for Prior year rolling 12 month ?
Based on my research, your measure should achieve below data:
You could also download my pbix file to have a view.
Regards,
Daniel He
@Anonymous seems like your measures are not workign as expected. In the table it should show previous year rolling measure next to current year rolling and that is the case you are not getting expected result.
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
User | Count |
---|---|
139 | |
113 | |
104 | |
77 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |