according to dates , need respective dates data only, not cummulative

[Anonymous]

i have two sheets,  one have dates & ID and other sheet have task per week and date ID as attcahed in pic. in data model in have linked  dates id with dates id but when i click on respective date ,it show me cummlative result , i need per week task, not cummulative.
in last pic can see its showing cummulative results

[Anonymous]

Hi @Anonymous ,

According to your statement, I think you create a relationship between two tables based on [Date ID].

You filter the vsiual between 2023/11/03 and 2024/10/24. There are data on 2024/10/17 and 2024/10/24 in your data table. So the visual will show all data in date range.

I think the result in your screenshot is correct. Could you show us the screenshot with the result you want?

You could also share a sample file with us, this will make it easier for us to find the solution.

Best Regards,
Rico Zhou

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

[BeaBF]

@Anonymous Hi! Try to set the relationship "Single" instead of "Both"

BBF