Hello,
I have 2 Matrix visuals on 1 page, and they are identical except for the year they are displaying the data for. I have aging categorys in the columns (0-30 days, 31-60 days, etc.), and Reason Code in the Rows (Freight, Returns, Pricing, etc.) - I would love to be able to click on a reason code in 1 Matrix, and for it to filter both visuals on the selected reason code, but because I have each Matrix set to a different year, it is not filtering the other Matrix, just making it go blank.
Is there a way to click on a Reason Code and have Power BI ignore the Year, but still filter the rest of the page on the selected Reason Code?
Thanks,
Dan
