Help with date filter

[mmatheuscc123]

Hi, guys! I need help with dates. 

In my dash, I have a date filter and I need to show some infos, they are, Day results, month results and year to date results. But when I filter one date, ex 30/11/2021, the dash show in all big numbers (day, month and year to date) only the day info. How can I to do?

[v-zhangti]

Hi, @mmatheuscc123 

Can you provide example diagrams and the output you expect? Sensitive information can be removed in advance.

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.

[jaipal]

@mmatheuscc123  you need to run the totals for Month and Year to day. Then you able to see the correct figures. 

you can do this through DAX or Power Query.

Follow the links 

For DAX:

https://community.powerbi.com/t5/Desktop/Running-total/m-p/502657

For Power Query:

https://www.youtube.com/watch?v=cP4zpnOmgM4