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.
Community SupportHi 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.
Helper IIIThank 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.
- v-kpoloju-msft
Hi DutchMark,
After thoroughly reviewing the details you provided, I was able to reproduced the scenario, and it worked on my end. I have used it as sample data on my end and successfully implemented it. It dynamically updates the values when modifications occur in the slicer.
outcome:
I am also including .pbix file for your better understanding, please have a look into it:
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 guess this topic is not going to give the outcome I want.
I have repeatly stated what I'm looking for, but not one solution gives this reply. I give up and keep my current chart. It's not worth the time anymore. Thank you for replying.
"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."- v-kpoloju-msft
Hi DutchMark,
Apologize for the delayed response could you please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question. Please show the expected outcome based on the sample data you provided.
Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...
Thank you for your understanding and participation.