Forum Discussion
Helper IIIComparing last 12 months to previous 12 months (partial problem)
Hi DutchMark,
We sincerely apologize for the inconvenience caused.
As the issue is still not yet resolved, we kindly request you to raise an issue at Issues - Microsoft Fabric Community for investigation.
Otherwise raise a Microsoft support ticket using the link provided below. They will be able to provide specific insights related to your account and potential resolutions.
Microsoft Fabric Support and Status | Microsoft FabricIf you find our response helpful, kindly mark it as the accepted solution and provide kudos. This will assist other community members facing similar queries.
Thank you.
Helper IIINo one?
Community SupportHi DutchMark,
Apologize for the delayed response. Thanks for the follow-up question. I again reproduced the scenario with my sample data with combo chart diagram. I got this outcome below shown in the image.
Attached is the .pbix file. Could you kindly review it. If the issue continues, kindly provide more precise sample data along with the expected behaviour. This will help us resolve your issue more efficiently.
If this post helps, then please give us ‘Kudos’ and consider Accept it as a solution to help the other members find it more quickly.
Thank you for using Microsoft Community Forum.
- DutchMark
Thank you, but it really needs to look like the chart I already shared and it doesn't look like that at all. More sample data is not going to help. I need a way to put 2 years next to eacht other per month, like shared in the first chart.
- v-kpoloju-msft
Hi DutchMark,
After thoroughly reviewing the details you provided, I was able to reproduce the scenario, and it worked on my end. I have used it as sample data on my end and successfully implemented it.Output:
Note: if you want to use this report, please have a slicer with year filter where you will get previous year to the current year comparison. dynamically determine the last 12 months measure is causing the problem
If this post helps, then please give us ‘Kudos’ and consider Accept it as a solution to help the other members find it more quickly.
Thank you for using Microsoft Community Forum.- DutchMark
Thank you, but I want to do it dynamically. I don't know maybe I'm not clear enough. Your chart has the same problem. In 2024-02 both charts called 2024-02 if you go over it. I want them to have the right name, so 2024-02 en and 2023-02.
Also again, my outcome is just fine, I just want those labels to be correct when I go over them.