Display the year on a card visual based on slicer settings

[Anonymous]

I'm working on a drill through page based on the total orders  for the month and year. On my report page I have a bar graph with the orders and a slicer with the year (2023 and 2024). 

On my drill through page I've figured out how to display the month on a card visual that is being drilled down but I cannot seem to display the year that I choose from the slicer. All that is displaying is the count of year.

Is there a DAX measure I can use to get around this bug? 

[Anonymous]

Yes that worked! Thanks!

[MFelix · Accepted solution]

Hi @Anonymous,

Create a measure similar to this and then use it on the card:

Selectsd Year = MAX(Table[Year])

I'm assuming you have a Year column on your model.