Reply
Jessica_17
Helper IV
Helper IV
Partially syndicated - Outbound

How to show 2 column values as column header instead of hierarchy in matrix/any other visualization?

I have one column which is in table A.

id1

QRC

SRC

MRC

I have one column which is in table B.

id2

QRF

SRF

MRF

 

OUTPUT:-

COLUMN HEADER:- 

ID |QRC| QRF| SRC| SRF| MRC| MRF

 

EDIT: This is just an example, In real scenario, each column contains more than 40+ values.

I want this output scenario to happen automatically in column, not dynamically using transpose function.

2 ACCEPTED SOLUTIONS
ryan_mayu
Super User
Super User

Syndicated - Outbound

@Jessica_17 

not sure if this is what you want

in PQ, appendix two tables

transpose tables

user first row as header

1.PNG2.PNG

pls see the attachment below





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

Syndicated - Outbound

what about merge two columns to get a new column and put that column to the matrix?





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

11 REPLIES 11
ryan_mayu
Super User
Super User

Syndicated - Outbound

@Jessica_17 

not sure if this is what you want

in PQ, appendix two tables

transpose tables

user first row as header

1.PNG2.PNG

pls see the attachment below





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Syndicated - Outbound

Yes, this is what I want, but I see you have converted it to columns using transpose and have selected each and every column to keep it in place,
But the question was an example, In future case I can have more than 40+ values in each column so instead of dynamically selecting that column, I want that it should happen automatically, all the column values should be shown as output columns without transposing it into various columns and selecting it.

Syndicated - Outbound

@Jessica_17 

what about we just appendix data and put the new column in a matrix?

 

pls see the attachment below





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Syndicated - Outbound

Thanks for the help,

I saw that column names are different, and I cannot change column names due to permission issues. and I edited the post accordingly.

Syndicated - Outbound

so you want the output to change from id1 and id 2 to ID?





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Syndicated - Outbound

Column name doesn't matter, column values matter in this situation.

Syndicated - Outbound

not quite understand this request. you said column names are different in the previous post. what's the problem you are facing after you used the solution i provided?





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Syndicated - Outbound

Column names are different , so it is being generated as 2 columns as shown in screenshot below

Jessica_17_1-1680082202647.png

 

Syndicated - Outbound

what about merge two columns to get a new column and put that column to the matrix?





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Syndicated - Outbound

Yes, It got solved thanks

Syndicated - Outbound

you are welcome





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




avatar user

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

Check out the March 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)