Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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.
When we select a value in table visual, the bar chart will be affacted as follows.
Best Regards,
Angelia
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.
When we select a value in table visual, the bar chart will be affacted as follows.
Best Regards,
Angelia
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |