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

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!