Reply
Highlighted
Regular Visitor
Posts: 24
Registered: ‎06-06-2017

IsLatest date filter on a table column

Hello everyone,

 

I have applied a date filter (IsLatest) on a table column in Power BI Desktop report (through edit queries) then I published to power bi service, now the problem is that, when I open the report in power BI desktop and click the refresh button it gets me the right data (with the latest date filter applied), but when I look over the same report embedded in my application it shows the data as it was the day I published the report (the IsLatest filter is not being reflected). is this normal? and are there any workarounds? 

Community Support Team
Posts: 6,970
Registered: ‎05-02-2017

Re: IsLatest date filter on a table column

Hi @cyan,

 

Could you share more details please?

1. How did you create "IsLatest" in the Query Editor?

2. Which time zone do you have?

3. Did it show expected result in the Power BI Service?

 

Best Regards,

Dale

Regular Visitor
Posts: 24
Registered: ‎06-06-2017

Re: IsLatest date filter on a table column

[ Edited ]

Hi @v-jiascu-msft,

1) To create the IsLatest, first I converted a column that I have in my table in date-time format to Date format, then I added date filter by clicking on the button at the top right of that column > Date Filter > IsLatest.

FilterOnDate.PNG

2) My timezone is (UTC-05:00) Eastern Time (US & Canada)

3) In Power BI servie the data in the report stays in the same date as the day I published, meaning that IsLatest filter is not being applied on the report in Power BI Service, but it is applying well in the report in Power BI Desktop.

 

Is it normal that the mentioned filter is not being applied in the report on power BI service? any suggestions?

Thanks.

 

Regular Visitor
Posts: 24
Registered: ‎06-06-2017

Re: IsLatest date filter on a table column

Hi @v-jiascu-msft any updates on this topic?

Community Support Team
Posts: 6,970
Registered: ‎05-02-2017

Re: IsLatest date filter on a table column

Hi @cyan,

 

Sorry for the late reply. The Islatest is a relative filter that means it has nothing to with with today. It filters out the latest dates of the source table. 

1. If the column contains date and time, I would suggest create a new column with pure dates.

2. Did you refresh the data in the Service?

 

Best Regards,

Dale

Community Support Team
Posts: 6,970
Registered: ‎05-02-2017

Re: IsLatest date filter on a table column

Hi @cyan,

 

Sorry for the late reply. The Islatest is a relative filter that means it has nothing to with with today. It filters out the latest dates of the source table. 

1. If the column contains date and time, I would suggest create a new column with pure dates.

2. Did you refresh the data in the Service?

 

Best Regards,

Dale

Regular Visitor
Posts: 24
Registered: ‎06-06-2017

Re: IsLatest date filter on a table column

Hi @v-jiascu-msft,

 

 I did create a new column with data type as pure date and applied the IsLatest filter on it, it works on power bi desktop but in Power BI service the filter in not applying.

Also I did refresh in Power BI Service, by clicking on the refresh button on the top of the report and also I did refresh on the Dataset level in power BI Service, but the filter is still not reflecting IsLatest date.

Is there another type of refresh in the Power BI Service that I should do? 

 

Thanks.

Regular Visitor
Posts: 24
Registered: ‎06-06-2017

Re: IsLatest date filter on a table column

Hi @v-jiascu-msft,

 

Do you think that the filter is desinged to work only on the local version but doesn't work when you publish to Power BI service? were you able to produce the problem?

 

Thanks.

Community Support Team
Posts: 6,970
Registered: ‎05-02-2017

Re: IsLatest date filter on a table column

Hi @cyan,

 

I think I found the root cause. Did you set up Schedule Refresh in the Power BI Service? Or refresh the dataset manually in the Power BI Service? If you want to show up the latest data in your embedded application, you have to refresh the dataset first.

Is_Latest_date_filter_on_a_table_column

 

 

Best Regards,

Dale

Regular Visitor
Posts: 24
Registered: ‎06-06-2017

Re: IsLatest date filter on a table column

Hi @v-jiascu-msft,

I have scheduled refresh, plus my report is connected to the source with Direct Query, also to make sure, I did manual refresh for the dataset like you mentioned, the dataset is updated because I have other pages in the same report where I don't use the IsLatest date filter and those pages are updated but the page with IsLatest Date filter keeps showing old data.

Is the IsLatest filter working for the test report you created? are you able to see the data filtered by the latest date in Power BI Service? If it's working for you do you think it's not working for me because I am using Direct Query!!? 

 

Thanks.