Forum Discussion
Adding Gridlines to Matrix columns
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 ther...
HI, jbhwcm
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.
For example:
select matrix visual
then click Format->Subtotals->Font color and Format->Grand Total->Font color
Result:
Best Regards,
Lin
This idea to use subtotals column to separate quarters worked pretty well for me. I simply changed the text format background to match the font color so that it appears there are no values. Ended up with something as shown below (grey columns separate quarters in the year). thanks!