Forum Discussion
How to create a matrix visualization with data from different tables (fields) with same column names
Hi red_arrowhead ,
What is the structure of your table? The first screenshot or second?
Could you please provide a mockup sample based on fake data or describe the fields of each tables and the relations between tables simply?
It will be helpful if you can show us the exact expected result based on the tables.
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.
The data I want to display in visulization is as below.
There are data for all calander weeks which are calculated by formula in Power BI data tab.
There are two different data sets similar to the screenshot above both having a column called Type and corresponding data for all 53 calander weeks.
Now I want to have a visulization table with this data specifflically for selected CW. I want this data to be merged into visulization. along with dymanic selection of which columns to dislpay.
Currently the issue is:
This is the screenshot of the matrix visulzation I have created. I have columns from CW 01 to CW 53. But after popolating the data from first table, the data from new table starts populating by creating new column sets CW 01 to CW 53. I want the data for both tables together. Also I used a slicer to select the CW to display, but I am not able to dynamically select the columns.
How can I do these ?