Forum Discussion

Saifi's avatar
Saifi
Frequent Visitor
7 years ago
Solved

More Relative Date filtering issues

I am having an issue with a published report contains visualizations created from transformed tables (Using Query Editor), the issue seems to be related to relative dates filtering. Here is what I a...
Need Help
  • Saifi's avatar
    Saifi
    7 years ago

    OK, here is what I found, and please correct me if any of facts are OFF.

    When we open  a data source in the query editor (DirectQuery mode) and do the data transformation bit and include any relative date filtering, when we publish the report the explicit date is passed, so if we set date is current dat the explicit day/month/year is passed to the service, and the report will keep filtering on that specific date. However, when we get the data source (DirectQuery Mode) from the report page and filter against relative date, the report will keep the relative date peoperly and every day the report chnages the date in needs to filter against.

    I am not sure if this related to the fact that in Query Builder we use M language and in BI report tool we use DAX?

    Eitherway, it would be nice to see that fixed as Report level filtering is more effective and robust.

     

    -Waleed

v-lili6-msft's avatar
v-lili6-msft
Community Support
7 years ago

HI, Saifi 

Do you have refreshed the report and try it again.

 

Best Regards,

Lin

 

  • Saifi's avatar
    Saifi
    Frequent Visitor
    7 years ago

    Refreshing the report does not solve the problem as it is using the explicite date. When you refresh the repot it gets the data from yesterday, it does not flip to today's date.

    I desigend the report to use relative date which equal Today.

    That works as long as the date stays the same, once a new day comes in the report data does not change anymore.

     

    -Waleed