Forum Discussion

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

Filter By Year Dynamically

Hi,   I ran into a dead end that I like my graph display the Year from Current Year and to the following 5 consecutive year (2018-2022) dynamically without having me filter or slice it manully each...
Need Help
Show and Tell
Tutorial Requests
Stuznet's avatar
Stuznet
Icon for Helper V rankHelper V
7 years ago

marcoslopezthank you for your input. I tried your suggested function.

Column = IF(YEAR([Date]) < YEAR(TODAY()),1,0)

I'm getting the same result as it shown on the chart from above. 

v-yulgu-msft's avatar
v-yulgu-msft
Icon for Microsoft Employee rankMicrosoft Employee
7 years ago

Hi Stuznet,

 

Please add below measure to visual level filters and set its value to 1.

CheckMeasure =
IF ( YEAR ( SELECTEDVALUE ( Table[Date] ) ) >= YEAR ( TODAY () ), 1, 0 )


Best regards,

Yuliana Gu

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

    v-yulgu-msftI've tried the function you provided, unfortunately it is not the result I'm looking for. 

    I filtered is "1".

    .

     

    I would like to see the result from 2018 to 2023 like it shown below the chart.

     

    And so for next year start from 2019 to 2024. 

     

    Thank you for your help.

    • v-yulgu-msft's avatar
      v-yulgu-msft
      Icon for Microsoft Employee rankMicrosoft Employee
      7 years ago

      Hi Stuznet,

       

      Please change the X-axis type from categorical to continuous for a test. If it still doesn't work, please share your .pbix file so that I can check for you.

       

      Regards,

      Yuliana Gu