Forum Discussion
matrix Primary and secondary Column level separator
Hi Ajithrjaa
The matrix cannot support custom the grid color, maybe you can consider to format background color to group them, based on the sample I have provided above, create a measure
Measure = SWITCH(SELECTEDVALUE('Table'[Type]),"A","red","B","green","C","blue","D","yellow")Then put it to the conditional formatting of background color
Output
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Ajithrjaa
It cannot directly set the color of the hierarchy, you can implement it by using matrix and shape.
e.g After creating the matrix, then add the line shape.
Set its rotation to 90.
adjust its border color and width, e.g if you want to display the first level column,set the color to dark grey. and set the width to 1px
if you want to display the second level column,set the color to light grey. and set the width to 0.5 px
Then group the lines and matrix at selection.(the selection option is at 'Format->Selection')
Output
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous amitchandak
Thanks for the response.
If my tablix having mutiple Column Scrool Bar is coming by default, then this approch is not sutable. PFA scren shot.
this statics lines not the way to approch.
Hi Ajithrjaa
The matrix cannot support custom the grid color, maybe you can consider to format background color to group them, based on the sample I have provided above, create a measure
Measure = SWITCH(SELECTEDVALUE('Table'[Type]),"A","red","B","green","C","blue","D","yellow")Then put it to the conditional formatting of background color
Output
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.