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.