Table grid column format colour

[htittoto]

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 

[Anonymous · Accepted solution]

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]

Hi,

This worked Perfectly!!!

Thank you very much!

[parry2k]

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