Forum Discussion
Solved
Joining two matrix visualisation based on the same rows
Hi team! I currently have 2 tables sharing the same rows and I want to see how I can join them together to make the visualisation easier to see. Table 1: Region Employement Type 1 Employemen...
Hi,
PBI file attached.
Hope this helps.
Hi,
In Power Query, merge Table2 into Table1 based on the Region column. Then right click on the Region column and select "Unpivot Other Columns". Click on Close and Apply. Now create a matrix visual and write this measure
S = sum(Data[Value])
Hope this helps.