Forum Discussion

htittoto's avatar
htittoto
Frequent Visitor
4 years ago
Solved

Table grid column format colour

Hello, 

 

I have a table with "Switch values to rown" turned on. It has a lot of measures and the columns are divided by company and year. 

Does someone know if there is a way to change the colour of the grid line of the columns by group, so it becomes easier to read?

Thanks,

 

Examples 

 

Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi htittoto ,

     

    You could consider to use other elements such as background color or font color. Then use conditional formatting feature.

    For example:

    Create a measure like below and manage conditional formatting.

     

    Measure = SWITCH(SELECTEDVALUE('Table'[Column4]),2021,"red",2022,"blue")

     

     

    Best Regards,

    Jay

3 Replies

  • parry2k's avatar
    parry2k
    Super User
    4 years ago

    htittoto I don't think there is a way to control the color of the lines between the different groups. 😞

     

    ✨ Follow us on LinkedIn and  to our YouTube channel

    I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make effort to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

     

    ⚡ Visit us at https://perytus.com, your one-stop shop for Power BI-related projects/training/consultancy.

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi htittoto ,

     

    You could consider to use other elements such as background color or font color. Then use conditional formatting feature.

    For example:

    Create a measure like below and manage conditional formatting.

     

    Measure = SWITCH(SELECTEDVALUE('Table'[Column4]),2021,"red",2022,"blue")

     

     

    Best Regards,

    Jay

    • htittoto's avatar
      htittoto
      Frequent Visitor
      4 years ago

      Hi,

       

      This worked Perfectly!!!

       

      Thank you very much!