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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

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

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

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

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.