Multi column Matrix or Table

Yes, you can do this in Power Query Editor unpivot.

Click Transform Data in home tab to open Power Query Editor.

Select UnitID and Sales Amount columns. In the Transform tab click Unpivot other columns.

You'll now have an 'Attribute' and 'Values' column. Rename these 'Description' and 'Unit'

This will only work if SalesAmount column is unit price. If it is total you will need to be a bit careful with how you use SalesAmount.

Then in Home tab, click Close and Apply. Then just add Description, Unit and Sales amount to a table or matrix visualization.

Has this post solved your problem? Please mark it as a solution so that others can find it quickly and to let the community know your problem has been solved. 

If you found this post helpful, please give Kudos.

I work as a trainer and consultant for Microsoft 365, specialising in Power BI and Power Query. 

https://sites.google.com/site/allisonkennedycv