Transforming values in a single column to column header

[vips]

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!

[v-gizhi-msft]

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

[Anonymous]

@vips 

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

[amitchandak]

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.

[Anonymous · Accepted 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

[vips]

This worked great!! Thanks!