Forum Discussion

Helper 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...

Tutorial Requests

Helper I

7 years ago

Hi Stuznet, you could create a calculated column that shows 0 if year(date) < year(today) and the value with future dates.

Hope this help you, apologies for my bad english :smileyhappy:

Best Regards, Marcos

Stuznet
Helper 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.
- marcoslopez
  Helper I
  7 years ago
  That I said was sth like having Column Total Invoices then
  New Calculated Column:
  Total Estimated Invoices =
  if (
  year(InvoiceDate) >= year( today() );
  Total Invoices;
  0
  )
  - Stuznet
    Helper V
    7 years ago
    marcoslopezI tried that and it giving false result.
    Column = IF(YEAR([Date]) >= YEAR(TODAY()),[Total],0)
- v-yulgu-msft
  Microsoft 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
    Helper 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.