Forum Discussion
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
| Details | Complaince |
| Measure 1 | Value of Measure |
| Measure 2 | Value of Measure |
However Currently as per design it will come like shown below
| Measure1 | Measure 2 |
| Value of Measure | Value of Measure |
Kindly help to fix this issue
Hey, use unpivot option.
Hi pdindukurthi
Just simply use this option under values setting of Matrix visual.Just simplt turn on switch values to row under Values setting then Option
Put your row header into the column section then you the result
I hope I answered your question!
3 Replies
- Uzi2019
Community Champion
Hi pdindukurthi
Just simply use this option under values setting of Matrix visual.Just simplt turn on switch values to row under Values setting then Option
Put your row header into the column section then you the result
I hope I answered your question!
- pdindukurthi
Helper I
Thank you that worked
- JohnjoseFrequent Visitor
Hey, use unpivot option.