Column Creation

[abukapsoun]

Hi,

need your support please,

I have the following table:

Col1    Col2                  Col3    Col4

X         Sales Margin    10         Q1

X         Sales                 15         Q1

Y         Sales Margin     20         Q2

Y         Sales                 35          Q2

How can I create a stacked columns, where i can show the Sales column next to Sales Margin per Quarter? 

Thanks

[AiolosZhao · Accepted solution]

Hi @abukapsoun ,

I created two versions, are these what you want?

Aiolos Zhao

[amitchandak]

 Can you share expected output.

[abukapsoun]

Hi,

something like that 

[v-chuncz-msft · Accepted solution]

@abukapsoun 

Here is a similar case for your reference.

https://community.powerbi.com/t5/Desktop/Want-to-split-a-table-up-by-a-dimension/td-p/888385

[AiolosZhao · Accepted solution]

Hi @abukapsoun ,

I created two versions, are these what you want?

Aiolos Zhao