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

Inserting Excel matrix into Power BI table

I currently have a slicer where the user selects the origin and a list of destinations are shown with their distance in miles. I am wanting to add another column after distance to be days to destination from the one origin to all the destinations. This information is housed in an excel matrix and I am unsure how to add it to the table as a column. There are photos below showing the slicer and table and also the excel matrix. Any information would be greatly appreciated.

m&s.PNGmatrix.PNG

1 ACCEPTED SOLUTION

Accepted Solutions
Super User II
Super User II

Re: Inserting Excel matrix into Power BI table

One option is to unpivot your Excel matrix to arrive at a table with these columns 

 

Place A     Place B     Distance

 

For simplicity you may want to repeat the table with Place A and Place B swapped.

Then you can link that to your other tables.

View solution in original post

4 REPLIES 4
Super User II
Super User II

Re: Inserting Excel matrix into Power BI table

One option is to unpivot your Excel matrix to arrive at a table with these columns 

 

Place A     Place B     Distance

 

For simplicity you may want to repeat the table with Place A and Place B swapped.

Then you can link that to your other tables.

View solution in original post

Highlighted
Super User IV
Super User IV

Re: Inserting Excel matrix into Power BI table

@hamatter , the data you shared and the output you want I am not able to relate. It needs to copy two to display this .

Can you share sample data and sample output in table format?



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

Highlighted
New Member

Re: Inserting Excel matrix into Power BI table

I followed your advice. Thank you!

Highlighted
Community Support
Community Support

Re: Inserting Excel matrix into Power BI table

Hi @hamatter 

 

If you've fixed the issue on your own please kindly share your solution. if the above posts help, please kindly mark it as a solution to help others find it more quickly. If not, please kindly elaborate more. thanks!

 

Community Support Team _ Dina Ye
If this post helps, then please consider Accept it as the solution to help the other members find it more
quickly.

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Tech Marathon

Maratón de Soluciones de Negocio Microsoft

Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!

Top Solution Authors
Top Kudoed Authors