Forum Discussion
jbhwcm
Advocate I
Advocate IAdding 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 everyone,
For a vertical separator, you can use the following workaround:
- Create a measure that returns a blank (example: Separator Measure = BLANK() )
- add it as a column where you need the separator to be
- rename the label to a “.”
- change the Font color and Background color to be the exact same.
- resize the column to the desired size (I normally shrink as much as it allows me to).
If you need more separators just add the same measure to the table or matrix again.
I hope this helps until the PBI teams provides with a proper way of accomplishing this.
bilboAdvocate I
Advocate IThank you for this solution! It is crazy that it is 6 years later and Microsoft still has not implemented this basic functionality