Forum Discussion

derrydev's avatar
derrydev
Frequent Visitor
1 year ago

Bins/Buckets Issue when filtering on dates

Hi all,   I am working with data bins/buckets.   I have attached a link to a pbix file containg visuals and data. Bins Forum Question.pbix I have a main Fact dataset called Interactions which...
Need Help
Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi, derrydev 

 

You can try the following methods. Delete the relationship between these two tables.

The calculations at this point are as follows.

Is this the result you expected?

 

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

derrydev's avatar
derrydev
Frequent Visitor
1 year ago

Hi there Anonymous ,

 

Thank you for your assistance.

Almost there.  When adjusting the date slider all 3 data boxes now update accordingly.

However, there is now no interaction between the visuals. So in screen grab below top right when can see 3 customers with band 1-4.  Clicking the 3 value does not filter the top left box, ideally the top left should filter to the 3 customers, Barney, D and Fred highlighted in yellow line and the bottom detail box should also filter to these.