Forum Discussion

Mattwilson1981's avatar
Mattwilson1981
Frequent Visitor
7 years ago

Embedded date filter ignoring the first date

Hi guys and dolls, 

I have a report that uses an invoice date (Format YYYY-MM-DD) as a filter, this embedded report has a slicer to allow either a relative date range or a manual date range.  The manual date range uses GreaterThanOrEqual and LessThanOrEqual.  When I use a date range in either PowerBI Desktop or website it includes the first date.  However when I use the embedded version whatever date I select for the start will be ignored.  

 

In this test it returns data beginning 02/10/2018

operator: "GreaterThanOrEqual"value: "2018-10-01T00:00:00.000Z"

operator: "LessThanOrEqual"value: "2019-09-30T00:00:00.000Z"

 

If anyone can help that would be great, merci

No RepliesBe the first to reply