matrix Primary and secondary Column level separator

[Ajithrjaa]

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

[Anonymous]

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.

[Ajithrjaa]

@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.

[Anonymous · Accepted solution]

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.