PBI Matrix - Vertical Grid Lines on only a few columns

[ldwf]

I have a PBI matrix and want to add vertical grid lines, but only on certain columns.  See screenshot.  I want one grid line to separate the Past Due columns from the others, and one grid line to separate 'Coming Due' from the others, and one grid line to separate the 'Total' column.  I have tried creating a measure and defining it with BLANK() and adding that to the matrix.  That does help some, but it also adds more text in the column headers because of the additional column, which makes the visual look sloppy.  Is there a way to only add grid lines on specific columns, as shown in the screenshot?  I am trying to do this without physically adding shapes because the size of the visual changes based on what is selected in the slicer and based on what data is available, so if there is a way I can manually add a shape that adjusts based on the size of the matrix, or some other way, I'd like to know how

[Anonymous]

Hi @ldwf, 

Double click on the Column Name from the Build Visual panel on the right side of Power BI to update a column name to a space:

Result:

More information for your reference:

How to Hide Power BI Column Headers on a Table or Matrix Visual

Best regards,

Joyce

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[ldwf]

Unfortunately that doesn't work.  Your example does not show any fields in the 'Columns' pane.  I have a field in the Columns pane that provides all the breakouts - i.e, 'Past Due 1-10 Days', 'Past Due 10+ Days', etc.  I did create a blank measure and added it, but the matrix has a 'Blank Row' to provide a break whenever ther is a new value for the row header, and if I add the background color/font color for this new blank measure, it will also color the rows where each 'blank row'.  Also, both the row header fields and column header fields look sloppy  on the visual; i.e, there is a blank gap under the column headers and the row headers are not aligned with the column headers

[Anonymous]

Hi @ldwf, thank you for your feedback. 

As far as I know, we could only control the "global" vertical gridlines instead of only a few columns:

Best regards,

Joyce

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.