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?
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.
Regards
Miguel Félix
Did I answer your question? Mark my post as a solution!
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @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.
Regards
Miguel Félix
Did I answer your question? Mark my post as a solution!
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHelpful resources
Join our Fabric User Panel
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Power BI Monthly Update - June 2025
Check out the June 2025 Power BI update to learn about new features.
Fabric Community Update - June 2025
Find out what's new and trending in the Fabric community.
