matrix with columns of different data types

Hi FOXYBARK,

I would also take a moment to thank  danextian , MasonMA, selimovd for actively participating in the community forum and for the solutions you have been sharing in the community forum. Your contributions make a real difference.

Yes, you can create a matrix with columns showing different data types like numbers, dates, and text just add each field separately in the Values area. If your data is split across two tables, make sure there's a relationship between them using a common key like ProductID.

I tested it with my sample data, and it worked fine. Please find the attached screenshot and Pbix for your reference.

Hope the above provided information help you resolve the issue, if you have any further concerns or queries, please feel free to reach out to us.
Best Regards,
Harshitha.