Forum Discussion

Stuznet's avatar
Stuznet
Icon for Helper V rankHelper V
7 years ago

Freeze The Previous Data Trend Bar Graph

Hi all,

 

I've been googling around how to lock or freeze the previous month trend data on the Bar Graph but no avail. 

 

What I want is freeze Actual in January, so the next cycle when I refresh the report will not impact the previous month (January)

 

I've created a dummy report

 

I appreciated your help.

Need Help
Show and Tell
Tutorial Requests

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    HI Stuznet ,

     

    I modify your actual measure to add a condition to break calculation and grouped by current month name:

    Actual =
VAR Test =
    CALCULATE (
        SUM ( Data[Unit Cost] ),
        FILTER ( ALLSELECTED ( Data ), Data[Month Num] <= MAX ( Data[Month Num] ) ),
        VALUES ( Data[Month] )
    )
RETURN
    IF ( MAX ( Data[Month Num] ) + 1 <= MONTH ( TODAY () ), Test, BLANK () )

    Regards,

    Xiaoxin Sheng

    • Stuznet's avatar
      Stuznet
      Icon for Helper V rankHelper V
      7 years ago

      Hi Anonymous,

       

      Thank you for working on this for me, so, in theory, the measure you created it should stop adding the number to January when I refresh for the next cycle, is that right?

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        Hi Stuznet ,

         

        This formula will calculate until previous month of current date and they will filter by its row contents month.

         

        Regards,

        Xiaoxin Sheng