I would like to change the format of the PowerBI table

[Kai_yun]

I made a table in PowerBI, but what I want is not working well...

What I want is to show the Q'ty above and the Ratio below.

Like the photo below

However, in PowerBI, it looks like the below.

[Kai_yun]

Thank you for your quick answer!

I tried changing the value, but it's not what i want😂

I would like th share my PowerBI file, do you know how to share it?

[Ethan96]

Hi, @Kai_yun 

Enter a new table:

Then try mesaure like:

Values = SWITCH(SELECTEDVALUE('Table2'[Group1]),"Q'TY",SUM('Table'[Q'ty]),"Ratio",format(SUM('Table'[Ratio]),"percent"))

Sample file

If I misunderstand, please upload your file to cloud storage, set permissions and share the link here.

Regards,

Ethan

[Kai_yun]

I just want to share the original contents of the table.

I tried to copy what you teached me, but it didn't work normally....

1	Jan	0~1	A
1	Jan	1~2	A
1	Jan	2~3	A
1	Jan	3~	A
2	Feb	0~1	A
2	Feb	1~2	A
2	Feb	2~3	A
2	Feb	3~	A
3	Mar	0~1	A
3	Mar	1~2	A
3	Mar	2~3	A
3	Mar	3~	A
4	Jan	0~1	B
4	Jan	1~2	B
4	Jan	2~3	B
4	Jan	3~	B
5	Feb	0~1	B
5	Feb	1~2	B
5	Feb	2~3	B
5	Feb	3~	B
6	Mar	0~1	B
6	Mar	1~2	B
6	Mar	2~3	B
6	Mar	3~	B

[Ethan96 · Accepted solution]

Hi, @Kai_yun 

I made a new sample based on your current model and hope it works for you.

Sample file

Regards,

Ethan

[Ethan96]

Hi, @Kai_yun 

What's your first column? Can you provide names of these columns?

Regards,

Ethan

[bcdobbs]

Not sure it get's you exactly what you want but try a matrix and then go into format >> Values >> Show on Rows.

(Away from computer so apologies if labels are not exactly correct)