Forum Discussion

cazza's avatar
cazza
Frequent Visitor
1 year ago
Solved

Time Series Chart Showing Selected Data and Prior Period based on Slicer

Hi all,   I'm trying to get have a time series graph show the Current Period (slicer selection) and the Prior Period (which is one year prior, based on the slicer selection).   I have managed to ...
Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    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.

Ashish_Excel's avatar
Ashish_Excel
Icon for Solution Supplier rankSolution Supplier
1 year ago

Hi,

Does this pattern work?

Measure = sum(Data[Value])

Measure1 = calculate([Measure],sameperiodlastyear(calendar[date]))

cazza's avatar
cazza
Frequent Visitor
1 year ago

Hi,

 

I also have a scenario which is pretty much identical to the above except for the preceding period.  I have managed to get variables to give me the answer but still have the same issue trying to plot it on a graph.