Measure refresh problem.

[ppgandhi11]

I am very new to Power BI.

I have created a simple report with 2 parameters: StartDate and EndDate. So user can input them and based on that the query would run and report would be generated.

I have kept these 2 parameters (in Query Editor), Enable Load and Include in Report Refresh. So both are checked.

Now these 2 parameters are available in the Report Page. I have created a measure called "DashboardTitle". The definition is:

DashboardTitle = CONCATENATE("Time Period: ", CONCATENATE(FromDate, CONCATENATE(" to ", ToDate)))

I have used this measure in the card visual to display at the top so that user can see nice time period selected. Down below is the report that the query has fetched results for.

Problem is: every time I input the parameters and hit OK, the report gets refreshed with new parameter values but the date doesnt change in the title. I have to hit refresh again and then the dates would change.  Unless user clicks refresh, the dates are still old dates and the report is with new date which may lead to confusion for user.

Why doesnt the date change in the Title along with the data in the report? Any idea? Thanks.

[v-chuncz-msft · Accepted solution]

@ppgandhi11,

Alternatively, you may try using Slicers.