Quite new to PowerBI and having a hard time figuring out the most efficient way to do this. Would be greatful for any assistance.
Here's an exemple of what I'm trying to do:
Person | Favorite color | 2nd favorite color |
Alpha | Red | |
Bravo | Blue | Red |
Charlie | Red | |
Delta | Black | Yellow |
Echo | Yellow | Red |
In the real life scenario I have 6032 ''persons'' and 25 different ''colors'' and trying to using a bar chart the represent the % of persons having x color as 1st or 2nd choice.
Extra info:
- The data is imported from an excel file that will be updated every month so I'm trying to stick to things done in Query.
- There IS a concentration in the top 6-7 values (~85 total%)
Most efficient solution I see:
Creating custom columns in query like
If ‘‘Favorite color column’’ = RED or ‘‘2nd favorite color column’’, then = YES, or else = NO
And then repeating the step for the top 10ish values, but that means 10 columns.
This solution is very far from efficient and / or intelligent, anyone with anything better to get to my end result ?
Thanks in advance,
Med
