Relation between Bar Chart and Table Visual in PBI Desktop

[harshadsp]

Hello,

Need your help.

I have 2 visual. One is bar chart which is plotted against Zipcode and second one is a tale visual which contains the demographic data of that zip code. Both are 2 separate sql server tables which are joined with zipcode column (common in both tables) with 1:N relation in PBI. ZIpcode_detail is a master table and 2nd is detail tables, so 1:N relationship.

The bar graph is on details table (x axis has zipcodes)

The zipcode master table has its demographic data.

Now the relation is not working as expected. I have just 1 record (as of now) for zip code 10566 in master table. So when I select any other zipcode e.g. 11378 then the details table visual should not show any data in. It should only show data when 10566 is selected in bar chart.

Could you please advise what I am missing here?

Thanks

Harshad

[v-huizhn-msft · Accepted solution]

Hi @harshadsp,

I create sample table and test, please edit the cross filter direction as "Both" as follows. Then Bar Chart and Table Visual will affect with each other.



When you select a Zipcode value in bar chart, the table visual only display the related value.

select 11378select 11779
When we select a value in table visual, the bar chart will be affacted as follows.



Best Regards,
Angelia

[harshadsp]

Thanks @v-huizhn-msft.

It worked!