Forum Discussion
Time Series Chart Showing Selected Data and Prior Period based on Slicer
Hello cazza
Thank you for reaching out to the Microsoft Fabric Forum Community.I have successfully reproduced your scenario in Power BI and I was able to get the expected output as per your requirement where:
- The current period's data (based on slicer selection) is shown, and
- The prior year's data for the same relative period (one year back) is calculated and displayed side-by-side in the table.
This allows you to clearly compare performance between the selected time window and the equivalent period from the previous year.
For your reference, I’m attaching the .pbix file so you can explore the solution in detail.
If this information is helpful, please “Accept as solution” and give a "kudos" to assist other community members in resolving similar issues more efficiently.
Thank you.
Hi cazza
May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.
Thank you.
Hi cazza
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution so other members can easily find it.
Thank you.
Hi cazza
I hope this information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, please Accept it as a solution and give it a 'Kudos' so others can find it easily.
Thank you.