Forum Discussion

dbrandone's avatar
dbrandone
Icon for Helper IV rankHelper 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
Icon for Community Champion rankCommunity 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
    Icon for Helper IV rankHelper 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!!