Forum Discussion

jbhwcm's avatar
jbhwcm
Advocate I
7 years ago

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...
Need Help
clqLoveSpace's avatar
clqLoveSpace
Advocate II
5 years ago
v-lili6-msft wrote:

     After my research, I'm afraid it couldn't achieve in Power BI for now.

>2 years later and we still can't do this - is there any plan to implement this? I would also like to be able to do it.

 

In my case I want gridlines separating each row at the top level of my row hierarchy, without separating the sublevels.

 

i.e. Say I have a 'UserId' field and an 'OrderId' field. Each 'UserId' can have 1 or many 'OrderId's associated with it. I want to count the number of 'Items' in each order and subsequently the total number of 'Items' ordered by each user, so I have 'UserId' and 'OrderId' as different row levels. I should be able to have gridlines separating the 'UserId' field without also separating the 'OrderId' field, but the Matrix visual formatting options don't stretch this far. The same should be possible for columns.

 

This seems like it should be a pretty important design feature of a 'pivot table' style visual to help as a visual aid and I'm surprised Microsoft could overlook this so easily.