Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Jessica_17
Helper III
Helper III

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

@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

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

@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!




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.

@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!




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.

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!




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

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!




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

Jessica_17_1-1680082202647.png

 

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!




Yes, It got solved thanks

you are welcome





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

Proud to be a Super User!




Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

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

Top Solution Authors