Report Table with one column of relational data

[bschmiedeler]

Totally new to Power BI. 

I have two tables, Trips and Businesses. Trips table has BusinessID, Business table has BusinessID with Name and other data.

I want to be able to list Bushels by Business Name in a table, and Bushels by Commodity in another, etc. Below I show the table with the ID. How do I just show the Name, not the ID?

[bschmiedeler]

I cannot believe it is that easy. Geez. 

The commodity ID is in another table. 

I had already made all the relationships, so everything is working now.

[VasTg · Accepted solution]

@bschmiedeler 

Define relationship between the tables based on ID.

Remove the ID in your visual.

Where is the commodity name comes from?

If it helps, mark it as a solution

Kudos are nice too