cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
bestmbaman Member
Member

joining two tables by headers of one tables to the column of another

Hi,

I have a table with headers that I want to join to another table with the same values but in one column. When I create the join the line looks as dotted and it doesn't work because upon choosing one value, the other graph doesn't update accordingly. What is the solution in your view? The first table can't be transposed because I used it to create a visual that needs the headers to remain. I have attached a picture to explain it better.

Headers: apple, TALTI, GREEN, RIZ, APPLE, KIWI, PINE, MELON

photo_2019-05-09_21-23-16.jpg

5 REPLIES 5
Community Support Team
Community Support Team

Re: joining two tables by headers of one tables to the column of another

Hi @bestmbaman ,

 

Could you please share your sample data and excepted result to me if you don't have any Confidential Information. Please upload your files to One Drive and share the link here.

 

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.
bestmbaman Member
Member

Re: joining two tables by headers of one tables to the column of another

@v-frfei-msft 

Hi I have included an screenshot of the table, cn't you open it?


 

 

 


 

bestmbaman Member
Member

Re: joining two tables by headers of one tables to the column of another

@v-frfei-msft 

Hello! I am looking forward to hearing from you!

Super User
Super User

Re: joining two tables by headers of one tables to the column of another


@bestmbaman wrote:

The first table can't be transposed because I used it to create a visual that needs the headers to remain.


This does not sound right. You should transpose the data. Most visuals will work fine with the headers transposed. Post back with which visual you are trying to use if you can't get it to work with the transposed data.

bestmbaman Member
Member

Re: joining two tables by headers of one tables to the column of another

@d_gosbell,

I have another matrix for my actual sata set which is the source of the left stacked column chart in the below screenshot:

photo_2019-05-12_09-26-05.jpg

the right chart is built on the matrix of Target dataset which was shared above!

The actual data set matrix is +250 rows and I can't share it at all!

Is there a way to have a better visual to compare acutal and target in *ONE VISUAL* rather than two separated stacked viusals?!

@v-frfei-msft 

Thanks

Helpful resources

Announcements
New Topics Started Badges Coming

New Topics Started Badges Coming

We're releasing new versions of the badge that everyone's talking about. ;) Check your inbox for notifications.

MBAS 2020

Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors (Last 30 Days)
Users online (1,027)