Forum Discussion

trevor's avatar
trevor
Helper I
8 years ago

Problem with filtered report since January 2018 update

Since April 2018 update when filtering a visualization by date you have to type in the date in American format - the option to select a date from the calendar pop up no longer works.
General Comment
mmace1's avatar
mmace1
Impactful Individual
8 years ago

Did you try reinstalling Power BI? 

 

If yes - 

 

If you add a totally new date table, does the same issue arise with it?  You can add a quick Calendar table by going to 

 

Modeling > New Table

 

Then entering this:  

 

Calendar Table = CALENDAR(DATE(2017,01,01),DATE(year(now()),month(now()),day(now())))

 

Then if you tried to make a filter on that table - same issue, or does that one work? 

trevor's avatar
trevor
Helper I
8 years ago

Sorry, I'm not being clear.

 

The problem is with any table. If a field in that table has a date field and I want to filter the results by a date range, whereas before this update there was a small icon you could click to choose the date, that functionality no longer works.

 

A fascinating discovery I have made is that if I copy the offending table to a new page, hey presto! the functionailty returns.

 

So the actual solution to the problem is to create a new page, copy the table to it, go back to the original page and delete it, then copy the new copy back to it. Hopefully MS will fix whatever causes this in the next update - I have about 30 tables to do this to.

 

Maybe uninstalling/reinstalling might fix it = I'll give that a go if I get the time.