Forum Discussion

Ajithrjaa's avatar
Ajithrjaa
Frequent Visitor
2 years ago
Solved

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 darke...
Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    2 years ago

    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.

     

     

     

Ajithrjaa's avatar
Ajithrjaa
Frequent Visitor
2 years ago

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's avatar
Anonymous
Not applicable
2 years ago

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.