Forum Discussion
Unpivot or Transpose - carrying attribut with value
Was trying to do some data sorting. How do take the value and tie it to the attribut?
I wanted the value.1 to be table header carrying the value for each line. is that possible?
Hi Anonymous
You can use the Pivot Column feature. Select Value.1 column and click on Pivot Column, select Value column in Values Column box. Expand Advanced options and pick a proper aggregation type.
Result:
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
2 Replies
- BA_Pete
Super User
Hi Anonymous ,
I'm not sure I fully understand your desired output, but the current structure of your data per the screnshot is the 'correct' data structure for use within a Power BI model.
If you want to adjust the format in which it is displayed to the end user, then you would do this using a matrix visual, you wouldn't change the fundamental data structure behind the scenes.
Pete
v-jingzhangCommunity Support
Hi Anonymous
You can use the Pivot Column feature. Select Value.1 column and click on Pivot Column, select Value column in Values Column box. Expand Advanced options and pick a proper aggregation type.
Result:
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
