Forum Discussion

cyan's avatar
cyan
Helper I
8 years ago

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 o...
Need Help
v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
8 years ago

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

cyan's avatar
cyan
Helper I
8 years ago

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.

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.

 

  • cyan's avatar
    cyan
    Helper I
    8 years ago

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

    • v-jiascu-msft's avatar
      v-jiascu-msft
      Microsoft Employee
      8 years ago

      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

    • v-jiascu-msft's avatar
      v-jiascu-msft
      Microsoft Employee
      8 years ago

      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

      • cyan's avatar
        cyan
        Helper I
        8 years ago

        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.