Apply a date value (currently held in a measure) to whole report

[pkoel-asb]

Hello,

   I want to allow the report user to select a date range. I created a measure to hold the user's selection. the code is below:

rptStrDate =

var x = max('Calendar'[Date])

var Startdate =

         switch(SELECTEDVALUE(TimePeriodFilter[SelectTiime]),

            "Year to Date", date(year(x), 1,1),

            "Rolling 12 Months", date(year(x),Month(x)-12,day(x)),

            "Last Year", date(year(x)-1,1,1),

            "All Data", date(2019,1,1))

return Startdate

How do I take the date value stored in rptStrDate and filter the whole report by it? I am unable to put the measure name in the filter box for Filters on all pages.

Cheers!

[v-xiaotang · Accepted solution]

Hi @pkoel-asb 

Thanks for reaching out to us.

>> How do I take the date value stored in rptStrDate and filter the whole report by it?  I am unable to put the measure name in the filter box for Filters on all pages.

you can only put field from the Fields pane into report-level filter

so as an workaround, you can set filter for each visual, for example, [rptStrDate] will return the date selected, then you can use it to filter the report by visual-level filter, Add a filter to a report in Power BI - Power BI | Microsoft Docs

create a filter measure,  filter= if(min('tabletobefilterd'[date])<[rptStrDate],1), then put [filter] into visual-level filter of the visual, then set 1 and apply.

Or 

you can set a date slicer and use ALLSELECTED() function, i.e. you can use sync slicer +Allselected() function, then you will get date filtered on all pages. Slicers in Power BI - Power BI | Microsoft Docs

Best Regards,

Community Support Team _Tang

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