Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
baneworth
Helper II
Helper II

combine 4 columns into 1 (conditional formatting with icons)

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.

 

icon merge.png

 

Thank you

Best regards

1 ACCEPTED SOLUTION
Bhu1singh
Frequent Visitor

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

View solution in original post

1 REPLY 1
Bhu1singh
Frequent Visitor

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.