How to create and arrange the column like that.

[rainchong7401]

Hi Guys,
Does anyone knows 
How should I group it like this ? (Expected Matrix Table)
Kindly advice & provide measure code and formula.
Will really appreciated.

Hi 

[ryan_mayu]

what does your data look like?

you can transform the data and put qty and sales in one column

[rainchong7401]

Hi Ryan,
I've no idea how to transform into 1 column.
Do you mind to guide me step by step?
I'm very new to Power BI 

[ryan_mayu]

its better to provide some sample data. If we know your data struction, we can provide proper solution for you.

pls see the attachment below to see if this is helpful

i did data transform in PQ

[rainchong7401]

Hi Ryan,
You may refer my data struction.
So that you will have more clearer picture

https://drive.google.com/file/d/14grQVsEBHFu6IES2y9zxWR4u41WUwr8C/view?usp=sharing

[ryan_mayu · Accepted solution]

@rainchong7401 

create a table

create a measure

Measure = if (SELECTEDVALUE('Table'[Column1])="qty",[CURPREV_SOLD_QTY],KEYMEASURES[CURPREV_SOLDL])

drag column1 and measure to the matrix

[rainchong7401]

Hi Ryan,
Btw do you join the relation? 
Bcuz for me I do not see like what you see

[rainchong7401]

Hi Ryan,
what if I have 3 columns now, QTY , AMOUNT & *NUMBER* (new columns)
How can I fit into measure down below ? 

Measure = if (SELECTEDVALUE('Table'[Column1])="qty",[CURPREV_SOLD_QTY],KEYMEASURES[CURPREV_SOLDL])

[ryan_mayu]

Measure = if (SELECTEDVALUE('Table'[Column1])="qty",[CURPREV_SOLD_QTY],if(SELECTEDVALUE('Table'[Column1])="amount",KEYMEASURES[CURPREV_SOLDL]),number)

[rainchong7401]

Hi Ryan,
Btw do you join the relation? 
Bcuz for me I do not see like what you see

[ryan_mayu]

no new relationship created. 

[rainchong7401]

Hi Ryan,
The qty 2020 looks kind of weird.
How come it fall under total instead of qty 2020? 

[ryan_mayu]

the easiest way is  to turn off the subtotals. 

[rainchong7401]

Hi Ryan,
I followed exactly what you did. 
But the result did not appear. 
Kindly assist.

[ryan_mayu]

pls try drill down the data

[rainchong7401]

Hi Ryan,
It doesn't work for me after drill down. 
Kindly assist.

[ryan_mayu]

pls check if you can download the file

https://1drv.ms/u/s!AgT7nVyoObZW4V3LbjpDOuHINyqS?e=68BWqm

[rainchong7401]

Hi Ryan,
Is it able to add font color or background color for every -1 year column data? 

[rainchong7401]

Hi Ryan,
For now It's working.
I've no idea why? 
Anyway thank you so much. 
Appreciated for your effort.

[ryan_mayu]

you are welcome

[rainchong7401]

Hi Ryan,
Is it able to add font color or background color for every -1 year column data?