Forum Discussion
Transforming values in a single column to column header
I have the following data
| Product ID | Year Shipped | Month Shipped | $ |
Month has values: Jan, Feb, Mar ... Nov, Dec
Need to transform this to:
| Product ID | Year Shipped | Jan | Feb | Mar | Apr | ... | Nov | Dec | $ |
Given that I am a newbie at Power BI, would appreciate pointers that a newbie can follow.
Many thanks!
Hi vips ,
I'm not sure whether you need to change your data model or show your data like that?
If you don't need to change your data model, you can use Matrix to make it like the below screenshot.
Aiolos Zhao
5 Replies
Hi vips ,
I'm not sure whether you need to change your data model or show your data like that?
If you don't need to change your data model, you can use Matrix to make it like the below screenshot.
Aiolos Zhao
This worked great!! Thanks!
- amitchandak
Super User
The best you can do
Product , year shipped, jan , feb , mar.
In case you need another column at the end, then you might have created a static column that will not be dynamic
I already submitted an idea for that please vote
https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/39773011-hybrid-table
Appreciate your Kudos.
And if you want to change your data model, you can use the Pivot function in the Power Query Editor.
1. Select the Month Shipped column
2. Click Pivot Column in Transform tab
3. Choose $ column, click OK
Aiolos Zhao
- v-gizhi-msft
Community Support
Hi,
According to your description, it is easily to reach your requirement by using matrix visual.
Here is my test table:
Then choose a matrix visual and turn off Stepped layout for Row headers:
The result shows:
Hope this helps.
Best Regards,
Giotto Zhi
