Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to 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
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
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |