Forum Discussion
Filtering Table with different relationships
Hi, I am using 2 different date columns for each bar visual (Forecast e6 date, e6 achieved date). I connect both of the date columns to a Dimcalendar table, and use CALCULATE...USERELATIONSHIP in the measures to calculate the count of each bars in both charts shown. I am struggling to get the bottom table to filter accordingly.
Example: I would like it to show the relevant job when I click on one of the weeks on the top barchart, and vice versa that it shows the relevant job when I click on the bottom bar chart.
Thank you!
Thanks for the reply from lbendlin.
Hi Anonymous ,
According to your description, the two bar charts cannot interact with the table. I tried to reproduce your problem.
The model is as follows:
This is due to the fact that the current relationship is inactive. Even when using the USERELATIONSHIP function, the function only activates the relationship when performing a summation calculation. It is recommended that both relationships be set as active to ensure that the bar chart and table can interact properly.
The new model is as follows:
Result:
Best Regards,
Zhu
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
Thanks for the reply from lbendlin.
Hi Anonymous ,
According to your description, the two bar charts cannot interact with the table. I tried to reproduce your problem.
The model is as follows:
This is due to the fact that the current relationship is inactive. Even when using the USERELATIONSHIP function, the function only activates the relationship when performing a summation calculation. It is recommended that both relationships be set as active to ensure that the bar chart and table can interact properly.
The new model is as follows:
Result:
Best Regards,
Zhu
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Zhu,
Thanks for your confirmation that the two bar charts cannot interact with the table by using USERELATIONSHIP. The reason that I am using inactive relationships is because the dates are from the same table. So, at least now i know that in order for me to get the right filters on the table, I need to split the dates to different tables and have active relationships for both.
Thanks again.
for better or for worse Power BI does support bidirectional search between tables (most often in a *:* relationship)
Please provide a more detailed explanation of what you are aiming to achieve. What have you tried and where are you stuck?
