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 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? 

Need Help

10 Replies

  • 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.