Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
powerbi_2022
Frequent Visitor

How to Unpivot the columns in Power BI Desktop

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.

 

powerbi_2022_0-1654841291343.png

 

2 ACCEPTED SOLUTIONS
Anonymous
Not applicable

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

View solution in original post

Anonymous
Not applicable

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

View solution in original post

4 REPLIES 4
Anonymous
Not applicable

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

Anonymous
Not applicable

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
Post Patron
Post Patron

Hello,

 

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

Can you give a small example?

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors