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.
Hi Greg_Deckler
So it is this that is causing my data to be repeated again and again, right?
As my data is currently repeating every single row for every single value of RunAmp. So if I manage to solve this, my data should be fine?
Thank you for your help.
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.