Forum Discussion
cbordner
2 years agoNew Member
Report Table One to Many Relationship Do Not Show Duplicate Entries
Power BI newbie here. In a report table from two tables with a one to many relationship, I would like to show a value from the "one" table only once. Examples follow.
What I currently see:
What I want to see:
Thanks in advance!
You can change the visual from a table to a matrix and turn off stepped layout and subtotals.
2 Replies
- jdbuchanan71
Super User
You can change the visual from a table to a matrix and turn off stepped layout and subtotals.
- cbordnerNew Member
Switching to Matrix was the trick I was missing. Thanks!