How to Unpivot the columns in Power BI Desktop

[powerbi_2022]

Hi All,

I have calculated columns in Power BI Desktop Query. Now I want to unpivot/transpose the columns in another query. Is there any way to do this? I don't want to unpivot using M-Query but through derived table in 'Fields' pane of Power BI Desktop. Derived table should look like below screenshot where Filter_Name and Value columns are unpivoted columns. Base query has multiple columns covered under column Filter_Name and Value column is the actual value of the respective column.

[v-cgao-msft · Accepted solution]

Hi @powerbi_2022 ,

See if these help.

powerbi - Is it possible to unpivot in Power BI using DAX?

DAX Unpivot

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly -- How to provide sample data

[v-cgao-msft · Accepted solution]

Hi @powerbi_2022 ,

Has the problem been solved? If you have solved it, you can post your solution here. If any of the replies are helpful to you, please consider marking it as a solution, it will help more users find similar issues faster. If the problem is not resolved, please feel free to let us know. Thanks in advance!

Best Regards,
Gao
Community Support Team

[v-cgao-msft · Accepted solution]

Hi @powerbi_2022 ,

See if these help.

powerbi - Is it possible to unpivot in Power BI using DAX?

DAX Unpivot

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly -- How to provide sample data

[SebSchoon1]

Hello,

Isn't it possible creating a calculate table using Summarize?

[powerbi_2022]

Can you give a small example?