Forum Discussion
Matrix visual not displaying the expected result
I tried this before but I couldn't append those 3 tables because I didn't have the same columns name.
But I found a workaround. I created a calculated column in each table where I concatanate the Subcategory and Category and I linked all the tables through this columns and then I was able to link the Data_Table with every table. After this I was able to see in the matrix the right values on the right column data for each measure.
Your idea of linking those 3 tables via calculated columns was useful, but the formulas were not changed because I got the correct result after I worked on the relationships.
Thank you lucadelicio for your ideas!
Another idea is in Power Query to create a single table that is the append of table + table1 + table2 with one more column that rapresent the DERIVATION TABLE (table, table1, table2).
Pay attention that in the append you must have the same name for the same columns.
In this way the time table insist only on one table that is the FACT table.
You have only one measure.
And in the matrix you put in the row the DERIVATION TABLE,
in the columns the period
and the measure as a value.
I think like this is more correct.
I tried this before but I couldn't append those 3 tables because I didn't have the same columns name.
But I found a workaround. I created a calculated column in each table where I concatanate the Subcategory and Category and I linked all the tables through this columns and then I was able to link the Data_Table with every table. After this I was able to see in the matrix the right values on the right column data for each measure.
Your idea of linking those 3 tables via calculated columns was useful, but the formulas were not changed because I got the correct result after I worked on the relationships.
Thank you lucadelicio for your ideas!
Happy to be helpful.