How to create a matrix visualization with data from different tables (fields) with same column names

Hi red_arrowhead ,

You can unpivot in Data tab using DAX, please refer this thread.

https://stackoverflow.com/questions/50213905/is-it-possible-to-unpivot-in-power-bi-using-dax

But it would be a huge DAX code because you have 53 columns. You need to UNION 53 times.

We suggest you can create the CW column in Query Editor, not using DAX. Then you can use the unpivot function.

If it doesn’t meet your requirement, could you please provide a mockup sample based on fake data in a pbix file?

Maybe we can find a way to solve your issue using M query.

Please upload your files to OneDrive For Business and share the link here. Please don't contain any confidential information or real data in your reply.

Best regards,

Community Support Team _ zhenbw

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.