Forum Discussion

dbrandone's avatar
dbrandone
Helper IV
4 years ago
Solved

ALLSELECTED help for use with multiple values

Hi Everyone,   I have a report that has button filters for years. I have a gauge visual grouping with one gauge showing the current year selected and the second gauge showing the previous year to t...
Need Help
  • AllisonKennedy's avatar
    AllisonKennedy
    4 years ago

    dbrandone  You can change your date to use MIN:

     

    VAR StartDate = DATE(MIN('Date'[Year])-1, 1, 1)
AllisonKennedy's avatar
AllisonKennedy
Community Champion
4 years ago

dbrandone  You can change your date to use MIN:

 

VAR StartDate = DATE(MIN('Date'[Year])-1, 1, 1)
dbrandone's avatar
dbrandone
Helper IV
4 years ago

Thanks AllisonKennedy

That works for the previous year measure, but with the first measure if ALLSELECTED is still used, it throws an error. If I use MAX, then only the max year of the two selected years shows in the data, but I was able to use your premise with MIN and MAX to get the currently selected year visual to display properly. Thanks!!