Forum Discussion

cbordner's avatar
cbordner
New Member
2 years ago
Solved

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

  • You can change the visual from a table to a matrix and turn off stepped layout and subtotals.

     

    • cbordner's avatar
      cbordner
      New Member

      Switching to Matrix was the trick I was missing. Thanks!