(SAC) apply background color from conditional formatting to other column

[carlbine]

I created a Calculated Measure and applied background color via Conditional formatting,

is it possible to apply the background color of the Calculated measure to all the cell of the same row? If not possible how can i put the Calculated Measure to the left side of the table?

[N1kh1l]

carlbine

carlbineRather than trying to drive formatting on measure I suggest you do it on Status (dimension). Select one row with status Ok and then try putting the styling row as below. Select Header and data for all dimension in your rows and only data for your columns.

Output: I have formatted only Direct Channel.

Repeat above steps again for Status = No by selecting only that row. My example Indirect Channel.

Hope this helps !!

Nikhil

[carlbine]

Thanks Nikhil.

If i have 30 rows of data it means i will do this 30 times?

[N1kh1l]

carlbine

007 🙂 I think It should be number of times you have unique status, I think its only OK and NG

Nikhil

[carlbine]

I haven't try this solution yet, 007 have just taken a long vacation. will update you soon and accept this answer.

Thanks Q.