Forum Discussion
See all rows in tabel visualisation
Anonymous - Well, it really shouldn't matter which one you choose. Keep the bridge table column and try changing those relationships to single direction versus Both.
Community ChampionAnonymous - I am very sure that if you solve the bridge table to have truly unique values so that in the relationships they show up as 1-* and not *-* then yes, there is a high probability that most of your headaches go away.
Hi Greg_Deckler
I tried to create your bridge table in Power Query. Reference your original queries and create 2 new queries that only have that column in them. Use an Append query to union them. Then do a Remove duplicates operation.
And it works! However, I get the errror message below and I cant seem to show the data.
- Greg_Deckler
Anonymous - Hooray! Task 1 accomplished, get an appropriate bridge table. Where are you getting that error? When you refresh or ?
Haha yeap task1 completed! I got that error when I tried to add RunAmp from the loadlist to my table visualisation according to the Cable Name and it states can't display visual and I got that error message.
- Greg_Deckler
Anonymous - OK, that's odd because I can see that the relationship exists between all those tables. Let's do a sanity check. How is your visual configured? You should be using the Bridge table's Cable Number in your visual and not the other Cable Number sitting in your other table.