Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
5 years ago
Solved

Plot showing 2-year evolution using year filter as reference date

Very good!! I have a dashboard that has a main filter per year, and a graph that shows the evolution of the data in the different years (I have data from 2004 to 2021). My intention is to display...
  • v-jingzhang's avatar
    v-jingzhang
    5 years ago

    Hi Syndicate_Admin 

     

    You can create a disconnected table which contains all the years in a column. Then create below measures.

    Selected Year = SELECTEDVALUE(Years[Year])


Flag = IF(SELECTEDVALUE('Date'[Year])<=[Selected Year]&&SELECTEDVALUE('Date'[Year])>=[Selected Year]-2,1,0)

     

    Put the Year column from Years table into a slicer for users to pick a year. Put the Flag measure into the visuals' filter pane as a visual-level filter and set show items when value is 1 and apply the filter. You need to have a column from Date table in the same visual to provide a context for the measure.

     

    Attached a sample file for your reference.

     

    Regards,
    Community Support Team _ Jing
    If this post helps, please Accept it as the solution to help other members find it.