combine 4 columns into 1 (conditional formatting with icons)

[baneworth]

Dear community,

in the screen below you can see 4 different columns where the value only ever occurs in 1 (of those 4).

Is there a way to merge them to one column instead and keep the icon formatting?

The underlying values are 1 or 0, so i thought a normal merge would make it not possible to distinguish between OK, open,.... anymore and therefore assign icons.

Thank you

Best regards

[Bhu1singh · Accepted solution]

Hi,
Create a new calculated column and use COALESCE function to merge all the values, and then use the newly created column in the visual, hope it should solve the problem.

Thanks

Bhuvan