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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

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
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.