Forum Discussion
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.
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.
4 Replies
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.
Anonymous , 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?
Hi Anonymous
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!
