How to change the cell background color based on dimension

dotnetfan — Wed, 08 Jan 2020 00:30:56 GMT

Hello,

I have a question on straight table. Does it possible to change the cell background color based on dimension?

For example, if the dimension equals to AAAA then all the cells background shows as red and for BBBB, shows as green?

Re: How to change the cell background color based on dimension

Arthur_Fong — Wed, 08 Jan 2020 00:49:53 GMT

In chart properties > Data > Columns > Dimension > Background color expression

> if(<Dimension>='<Value>',<Color>)