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
Highlighted
Super User V
Super User V

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
Highlighted
Super User V
Super User V

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 IX
Super User IX

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

Find your favorite faces from the community presenting at the Power Platform Community Conference!

Upcoming Events

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Upcoming Events

Community Summit North America – Join Online!

Join this community-driven Power Platform digital event for unbiased support and problem-solving.

Top Solution Authors