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 ChampionAny visualization group your duplicate data (any number of column selected) in to 1 and perform aggregation based on values.
In your case 3 will not repeat 3 times and you will see 3 one time and value as aggregation (either SUM, AVG or No summarization)
For unmatched data you can right click field and select "show items with no data" to get missing values
If you want to view all of your data from table 1, you need to create index column and bring that index column in visualization so that group can become separate and hence all rows will be return from table 1
you can refer this article
https://radacad.com/create-row-number-for-each-group-in-power-bi-using-power-query