Forum Discussion
Interaction not working
I have a table and a graph and I want the graph to respond when a "HW" is selected from the table so we can see what campaigns the HW was involved in, but it doesn't. I know interactions are the default - so I recreated them from scratch in case had inadvertantly changed something - but it made no difference. The data in the table comes from one table and the data in the chart another - and HW connects them through a one-to-many relationship.
Any sugestions as to why this interaction is not working?
Hi, GMonk55
It should be related to the measure formula you are using.
Please check whether you are using the function "All" in your formula.
If so, please try ro replace with function "ALLSELECTED ".
Best Regards,
Community Support Team _ Eason
5 Replies
- lukiz84Memorable Member
Can you show a picture of the relations?
- GMonk55Regular Visitor
Added to original post. Thanks
- lukiz84Memorable Member
Which column did you add in the bar chart? The one from campaign data or the one from LHW?
- v-easonf-msftCommunity Support
Hi, GMonk55
It should be related to the measure formula you are using.
Please check whether you are using the function "All" in your formula.
If so, please try ro replace with function "ALLSELECTED ".
Best Regards,
Community Support Team _ Eason
- GMonk55Regular Visitor
I've managed to solve this. Thanks for your support.