Forum Discussion
matrix Primary and secondary Column level separator
Hi Power Bi Pros,
I have a One cenario Could you pleasse give me some valueblae suggition on this approch.
I have a matrix visual in a power Bi but I want Primary Column Level Separator darker Color and Secondary separator column level lighter Color Saparator. my Primary field values havig a Single field values..
many thnaks.
IN
Expected output like
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.
3 Replies
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.
