Can't Display Visual in Table Visualization with Bridge Table

[Jojeh]

I've set up a bridge table to connect a fact table with a location dimension table. The bridge table includes a unique code from the fact table, as well as the country name and country ID from the location dimension table.

I've set up the relationships so that the fact table is connected to the bridge table in a many-to-one relationship, and the location dimension table is also connected to the bridge table in a many-to-one relationship in both directions.

I've been able to successfully create a matrix visualization that shows the location name from the location table and a value from the fact table. However, when I try to create a table visualization with the same data, I get an error message that says "Can't Display Visual".

I've checked and confirmed that there are null values in the code column of the fact table, which may be causing the error. I've also made sure that the data types of the columns used in the table visualization match and are compatible between the location dimension table, fact table, and bridge table.

I've tried removing some columns from the visualization to isolate the problem and identified that the issue may be caused by the null values in the fact table's code column.

I'm looking for tips on how to resolve the issue and get the table visualization to work properly.

I appreciate your help

[Jojeh]

I need a bridge because the location hierarchy of the fact table is lower than Dimension. meaning my Dimension table hierarchy starts with the location city name but in fact, starts with the location county name. 

Because the Dimension table is a data flow, I have to get the locations from the Dimension table. 

[amitchandak]

@Jojeh , why do you need a bridge table to connect Dimension to Fact? if Location to Fact is 1-M then fine. M-M can work in a few cases.

Also, you can design fact by merging location and fact and then have a new fact and location dim