How to link two table to enable filtering in power bi web?

[IvanP]

Hello!

I am new to PowerBI and I love the tool. Currently I am trying to reproduce the same scenario as shown in this video presentation (timecode 40:45): https://youtu.be/zaVGt-IbuhU?t=2445

As shown in the presentation, a person is working with two data graphics - stacked bar chart and a table. In stacked bar chart there are customers + their revenue (+avg. response time as color saturation). But for each customer and each process step there are different values.

I have tried to reporduce the same situation and I have created two tables in Excel (in sharepoint) with the following columns:

1) ID, Customer name, Revenue

2) ID, Process step, Value

(in the second table ID column is not unique, since each customer has multiple process steps)

Whenever I try to create a bar chart for the first column and a simple table for the second, I always get a sum in the second table. Selecting one customer on the first bar chart does not have any effect on the second. As if two tables are not "linked" with each other. How can I make that when clicking on one customer in the bar chart I will get values for selected customer and not the sum of all values?

Thank you very much in advance!

Kind regards,

Ivan

[v-huizhn-msft · Accepted solution]

Hi @IvanP,

In Power BI service, we can't create relationship between two tables. As the @Greg_Deckler posted, please upload your two tables into Power BI desktop. Then create the relationship between two tables. You can create report, then publish it to service. There are some features(like creating measures and calculated columns) in desktop version are not supported in service. So most time, you'd better create report correctly in desktop, and publish it to service. If you just use the dataset, youu can publish the dataset to Power BI Service, then create report in service. It's up to you.

Best Regards,
Angelia

[Greg_Deckler]

Hmm, don't think you can get there if you are in the Service only. Hopefully you are in Desktop. Then you can go to the data model (relationship) view, the third icon down on the left-hand side and link the two tables by dragging and dropping ID to ID.