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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel1

Power BI Monthly Update - May 2024

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