Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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!
Solved! Go to Solution.
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
Proud to be a Super User!
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
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
Proud to be a 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.
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
Proud to be a Super User!
This worked great!! Thanks!
User | Count |
---|---|
89 | |
73 | |
69 | |
64 | |
56 |
User | Count |
---|---|
98 | |
92 | |
84 | |
74 | |
66 |