How seperate column in power bi

[Anonymous]

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.

[Mariusz · Accepted 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

[adityavighne · Accepted solution]

HI,

In edit queries -right click on Medal-Copy column and -> duplicate it Then filter the column by Gold,Bronz etc.

[Anonymous]

Thanks

[Salvador]

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.

[Anonymous]

Thank you

[Mariusz · Accepted 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