cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Mattwilson1981 Frequent Visitor
Frequent Visitor

Slicer not working on embedded report

I have a report that has data betwen Oct-2019 and Feb-2020, I have a date range picker for the slicer which passes over a start and end date, however I am getting varied results with the date ranges.

 

This is the filter for year-to-date, which returns the correct data

  1. 0: {operator: "GreaterThan", value: "2020-01-01T00:00:00.000Z"}
  2. 1: {operator: "LessThan", value: "2020-02-14T23:59:59.999Z"}

This is the filter for the financial year, which doesn't work (view remains the same regardless of change in date)

  1. 0: {operator: "GreaterThan", value: "2019-03-31T23:00:00.000Z"}
  2. 1: {operator: "LessThan", value: "2020-03-31T22:59:59.999Z"}

This is the filter for the last 6 months which doesn't work (as above)

  1. 0: {operator: "GreaterThan", value: "2019-07-31T23:00:00.000Z"}
  2. 1: {operator: "LessThan", value: "2020-01-31T23:59:59.999Z"}

This is the filter for last 12 months, this returns the expected data

  1. 0: {operator: "GreaterThan", value: "2019-02-01T00:00:00.000Z"}
  2. 1: {operator: "LessThan", value: "2020-01-31T23:59:59.999Z"}

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

Power BI Desktop Update - February 2020

Power BI Desktop Update - February 2020

We are super excited for our update this month, as we are releasing two of our top community requests!

Power Platform Online Conference

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

Top Kudoed Authors