Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

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

 

 

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  : )     

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

    1. You need to add a blank measure:

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

    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 ) :

    Minimize with the mouse  the with of this column :

    Pbix is attached :

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

     

5 Replies

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

    1. You need to add a blank measure:

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

    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 ) :

    Minimize with the mouse  the with of this column :

    Pbix is attached :

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

     

  • 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's avatar
      Anonymous
      Not applicable

      Hi vibhormittal93 ,

       

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

    • Anonymous's avatar
      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?