Filtering between dates

[Anonymous]

I have a page that is filtered to show only data for todays date but I would like to be able to select between specific dates to get data but when I try everything shows 0. Is there a way to be able to show only todays data and be able to slice between dates to show the data between selected dates?

[v-gizhi-msft]

Hi,

Please try this measure:

Today Values = CALCULATE(SUM('Table'[Values]),FILTER('Table','Table'[Date]=TODAY()))

Choose this measure as a card visual, then choose date as a slicer, the result shows the today data and selected date duration data:

Hope this can help.

If you still have any issue, please give more info and share some sample data and expected result.

Thanks!

Best Regards,

Giotto Zhi

[amitchandak · Accepted solution]

If there is page-level filter from filter pane. then the only way to avoid is to use a measure that ignores that time values. Better you move that filter from page filter to a relative date slicer 

https://docs.microsoft.com/en-us/power-bi/visuals/desktop-slicer-filter-date-range

[rajendraongole1]

Refer this:

https://community.powerbi.com/t5/Desktop/Between-2-dates-in-FILTER-function/m-p/890552

https://community.powerbi.com/t5/Desktop/Filter-Measure-Between-Dates/m-p/918931

Hope it helps.