topic Re: Display the year on a card visual based on slicer settings in DAX Commands and Tips

Display the year on a card visual based on slicer settings

Anonymous — Tue, 18 Jun 2024 13:45:09 GMT

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?

Re: Display the year on a card visual based on slicer settings

MFelix — Tue, 18 Jun 2024 13:48:40 GMT

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.

Re: Display the year on a card visual based on slicer settings

Anonymous — Tue, 18 Jun 2024 13:54:34 GMT

Yes that worked! Thanks!