cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jbhwcm Frequent Visitor
Frequent Visitor

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 there a way to only do it for the years?

 

borders.jpg

4 REPLIES 4
Community Support Team
Community Support Team

Re: Adding Gridlines to Matrix columns

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

1.PNG2.PNG

Result:

3.PNG

Best Regards,

Lin

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
gidster99 Frequent Visitor
Frequent Visitor

Re: Adding Gridlines to Matrix columns

I would also like to be able to do this... or at least some way of better distinguishing the column groupings (in your case, the Years)

SH-VE Regular Visitor
Regular Visitor

Re: Adding Gridlines to Matrix columns

I too would like have such a feature to add border to specific column in matrix view

Highlighted
Super User
Super User

Re: Adding Gridlines to Matrix columns

@SH-VE @jbhwcm @gidster99  this can be achieve by turning on vertical grid and you can set the color the grid line and the thickness

 

image.png





Did I answer your question? Mark my post as a solution.

Proud to be a Datanaut! Kudos Help Smiley Happy
Connect with me on Linkedin. Feel free to email me with any of your BI needs.