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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
pdindukurthi
Helper I
Helper I

New Table or Pivot Table in PowerBI Desktop

Hi All,

I have a list of measures already created for a data set. 
Now we need to create a table visulazation with all list of measures in PowerBI Desktop however 

I need to create a table in this format

DetailsComplaince
Measure 1Value of Measure
Measure 2Value of Measure 

However Currently as per design it will come like shown below 

Measure1Measure 2
Value of MeasureValue of Measure

 

Kindly help to fix this issue 

 

2 ACCEPTED SOLUTIONS
Johnjose
Frequent Visitor

Hey, use unpivot option.

View solution in original post

Uzi2019
Super User
Super User

Hi @pdindukurthi 

Just simply use this option under values setting of Matrix visual.

Uzi2019_0-1714972089315.png

 

Just simplt turn on switch values to row under Values setting then Option

Uzi2019_1-1714972148050.png

 

 

Put your row header into the column section then you the result

Uzi2019_2-1714972203519.png

 

 

 

 

 

I hope I answered your question!

 

 

Don't forget to give thumbs up and accept this as a solution if it helped you!!!

View solution in original post

3 REPLIES 3
Uzi2019
Super User
Super User

Hi @pdindukurthi 

Just simply use this option under values setting of Matrix visual.

Uzi2019_0-1714972089315.png

 

Just simplt turn on switch values to row under Values setting then Option

Uzi2019_1-1714972148050.png

 

 

Put your row header into the column section then you the result

Uzi2019_2-1714972203519.png

 

 

 

 

 

I hope I answered your question!

 

 

Don't forget to give thumbs up and accept this as a solution if it helped you!!!

Thank you that worked

Johnjose
Frequent Visitor

Hey, use unpivot option.

Helpful resources

Announcements
Sept PBI Carousel

Power BI Monthly Update - September 2024

Check out the September 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Sept NL Carousel

Fabric Community Update - September 2024

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