The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
102 | |
82 | |
62 | |
56 |
User | Count |
---|---|
254 | |
119 | |
115 | |
100 | |
76 |