Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.

Reply
Anonymous
Not applicable

Vertical lines between columns on a matrix table

Hi everyone, 

 

I am looking to add some vertical lines to my matrix table so are some separation between each column. Is this currently possible? Thank you in advance

 

 

kalikumar_0-1697191853817.png

In this above image i need to show the line between months not the line between goal and actual.
It is Possible? Please help.

 

Thanks in advance  : )     

1 ACCEPTED SOLUTION
Ritaf1983
Super User
Super User

Hi @Anonymous 
This option isn't available as a format option, but you can achieve a similar effect with some workaround.

Ritaf1983_0-1699856151154.png

1. You need to add a blank measure:

blank = ""
2. Put it on values and give it a name with 1 char ( for example "."):
Ritaf1983_1-1699856288600.png

3. modify the colors of the text + background of this column to the wanted color and make sure that it is applying to all (Heather, values,totals ) :

Ritaf1983_3-1699856517441.png

Minimize with the mouse  the with of this column :

Ritaf1983_4-1699856599340.png

Pbix is attached :

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

 

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

View solution in original post

5 REPLIES 5
Ritaf1983
Super User
Super User

Hi @Anonymous 
This option isn't available as a format option, but you can achieve a similar effect with some workaround.

Ritaf1983_0-1699856151154.png

1. You need to add a blank measure:

blank = ""
2. Put it on values and give it a name with 1 char ( for example "."):
Ritaf1983_1-1699856288600.png

3. modify the colors of the text + background of this column to the wanted color and make sure that it is applying to all (Heather, values,totals ) :

Ritaf1983_3-1699856517441.png

Minimize with the mouse  the with of this column :

Ritaf1983_4-1699856599340.png

Pbix is attached :

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

 

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile
vibhormittal93
New Member

Hi @Anonymous ,

You can achieve the desired result by utilizing 'Vertical Gridlines' formatting option for a matrix.

 

Please mark it as answer if it resolves your issue. Kudos are also appreciated.

 

Regards

Anonymous
Not applicable

Hi @vibhormittal93 ,

 

          Yes it can. but i need to show the line between months not the secondary column name.

thuoc115
Advocate I
Advocate I

Can you insert into a column?

Anonymous
Not applicable

yes. but matrix can add 2nd level of column.
I need to show the vertical line in 1st level of column.

Is is possible?

Helpful resources

Announcements
September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors
Top Kudoed Authors