Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello everyone,
I like to seperate the column such that I can have Bronze and Gold in seperate column. Is this possible in Power BI? Many thanks for your help.
Solved! Go to Solution.
HI @Anonymous
You can use Query Editor to do this.
First select your Medal column then in Transform ribon click on Pivot Columns next select your Values Column (ID or Full Name), if you have only one unique column please duplicate it if you want to avoid agregation.
Hope this helps
Mariusz
HI,
In edit queries -right click on Medal-Copy column and -> duplicate it Then filter the column by Gold,Bronz etc.
HI,
In edit queries -right click on Medal-Copy column and -> duplicate it Then filter the column by Gold,Bronz etc.
Thanks
Hi,
You could also duplicate the column, so you would have two medal columns, and just rename them as bronze and gold, and use replace values (gold = blank, or whatever suits you).
Regards,
Salva.
Thank you
HI @Anonymous
You can use Query Editor to do this.
First select your Medal column then in Transform ribon click on Pivot Columns next select your Values Column (ID or Full Name), if you have only one unique column please duplicate it if you want to avoid agregation.
Hope this helps
Mariusz
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
126 | |
106 | |
105 | |
86 | |
72 |