Forum Discussion
How to create a matrix visualization with data from different tables (fields) with same column names
Hi red_arrowhead ,
Does your data structure like this?
And do you want to create a slicer using the first CW row?
If yes, you can refer the following steps.
1. Select Type column and unpivoted other columns.
2. Then we can create a matrix table like this,
If it doesn’t meet your requirement, could you please show the exact expected result based on the table that you have shared?
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.
BTW, pbix as attached.
Thanks a lot for your reply. It explains the problem. But there are few different things in my case. I cannot access those CW columns in power query because, I have calculated those in Power BI Data Tab from other columns as below
So, as they are calculated here in data tab, when I go to transform data, I cant see these CW columns there. So how can I make a slicer using those columns?
Also, CW 01 to CW 53 are present in two different sheets with there own dased on type and I want to merge those data based on cost type in visulization. For example, Data for Type A, B, C from sheet 1 for CW 1 and data for type D,E,F from sheet 2 for CW 1 should apper in single CW 1 column. But what currently happening is two different CW 1 are being created in visulization matrix, one for A,B,C data and another for D,E,F data. Similar for other 52 weeks as well.
I want to combine them and want dynamic CW 01-53 slicer.
The format how I want the visulization is
ith data for specific CW from both files together as per the type. And dynamic slicer using CW.
As I am unable to use power query for those columns how can I proceed?
