Forum Discussion

SammyNed's avatar
SammyNed
Helper I
2 years ago
Solved

3 full months trailing graph

Hi Everyone   Can someone please assist?   My stakeholders are excel lovers and want a view as below (dummy excel data).   If they select a month in the slicer, then the graph must show the t...
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi SammyNed ,

     

    Thanks for the reply from SachinNandanwar , please allow me to provide another insight: 

     

    I use these sample data to demonstrate.

     

    1. create a calculation table. And adjust the date format.

    Table =
DISTINCT(‘financials’[Date])

     

    2. create MEASURE.

    MEASURE =
VAR _cur_mon =
EOMONTH ( SELECTEDVALUE ( ‘Table’[Date] ), 0 )
VAR _3_mon =
EOMONTH ( SELECTEDVALUE ( ‘Table’[Date] ), -3 ) + 1
RETURN
IF (
MAX ( ‘financials’[Date] ) <= _cur_mon
&& MAX ( ‘financials’[Date] ) >= _3_mon,
1
)


    3. Filter the data in the bar chart where MEASURE is 1.

     

    If your Current Period does not refer to this, please clarify in a follow-up reply.

     

    Best Regards,

    Clara Gong

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.