I am trying to add borders/gridlines to separate the years in a date hierarchy for a matrix (as seen below). Is there any way to do this? When i turn gridlines on, it applies to each column, is there a way to only do it for the years?
After my research, I'm afraid it couldn't achieve in Power BI for now.
But you can color the total column to achieve your requirement.
select matrix visual
then click Format->Subtotals->Font color and Format->Grand Total->Font color