Forum Discussion
How do I put multiple tables that have the same categories into a single table?
Hi Anonymous ,
Thanks for clarifying. If you want the 3 visuals to be in the same order always you should try and get all these measures in a same table.
If they are already connected then it should not be a problem. But if the Category is not present in the Central table then you can create a new table by appending the Category column from all the tables and then removing duplicates.
This would create a Dimension or a Brige table. maybe you can show your value in a single table visual against this category.
Figured it out. I added a new custom column and entered the following code:
= each if [UNAIDEDAWARENESS.Service] = null then [FAMILIARITY.Service] else if [FAMILIARITY.Service] = null then [UNAIDEDAWARENESS.Service] else [UNAIDEDAWARENESS.Service])So basically where either column is null, do the value in the other column, and where they match (which is all other cases), just pick the first one (arbitrary).
Then did the same for uuids.
Solved: How do I dynamically merge two columns that contai... - Microsoft Fabric Community
I then formed a relationship between this new table and my central table, made all the measures I needed, using the two response columns that originally came from the two different tables, and put them all in a matrix.
Here's the result:
Now it can all be sorted together, too.
Okay so I realize that I have to do a full outer join (keeping all rows from both, but matching where possible), to preserve the extra rows that they don't have not in common. I also have to match both the uuid and category - this reduced the loading time significantly (otherwise it would've literally repeated every row for every category instead of matching them).
My issue now is that the table this gives me has seperate uuid and category columns for each question:
What I need is a single column for uuid and a single for category. But also taking into account that both have values that are not in common - so those would form extra rows.
Any idea how to do this?
Figured it out. I added a new custom column and entered the following code:
= each if [UNAIDEDAWARENESS.Service] = null then [FAMILIARITY.Service] else if [FAMILIARITY.Service] = null then [UNAIDEDAWARENESS.Service] else [UNAIDEDAWARENESS.Service])
So basically where either column is null, do the value in the other column, and where they match (which is all other cases), just pick the first one (arbitrary).
Then did the same for uuids.
Solved: How do I dynamically merge two columns that contai... - Microsoft Fabric Community
I then formed a relationship between this new table and my central table, made all the measures I needed, using the two response columns that originally came from the two different tables, and put them all in a matrix.
Here's the result:
Now it can all be sorted together, too.