Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have dataset like below:-
Col A | Col B | Value | Color |
A | a | 1 | RED |
A | c | 2 | |
B | b | 3 | RED |
C | c | 2 | RED |
D | a | 5 | Green |
D | c | 6 | |
E | b | 4 | Green |
F | a | 1 | |
F | c | 3 | Green |
G | b | 6 |
I need the output like this:-
Is there any work around to achieve this. Color Code will be assigned to the group as like (A,a), (B,b) and (C,c) and of RED groups and as per the groups the color should come into the Matrix, it should not be dependent on value. Is there any work around of achieving this may be not exactly but any alternative.
Guys please help need some idea on this, any alternative solution.
Only thing I can think of is an image underlay with transparency on your matrix. Ugh.