Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
105 | |
105 | |
88 | |
73 | |
66 |
User | Count |
---|---|
124 | |
113 | |
98 | |
80 | |
72 |