Using Visual-Level-Date Filters Breaks Visuals upon Refresh

[Evogelpohl]

I have several visuals on a report in which the visual is filtered to remove "this week's" data or to only show "this month and last month"  - which are created in Power Query

After I publish the report from PBID, all works fine on PowerBI.  But, when PowerBI.com refreshes my content, all of the visuals that are using a visual-level date filter get zero'ed-out.  Nothing is shown after the refresh (or multiple refreshes).  

However, all of the visuals on the report that DO NOT use a visual-level-date filter refresh properly.

Here is an example of some of the visuals-level date filters I'm using:

Date.IsInCurrentWeek([Date]) (Set the visual to FALSE)

[Rémi]

Hi,

If you don't get any error message, I don't think that the problem is from the refresh.

Are you sure that you get data in the current week?

Then I don't understand your context, you talk about visual-level-filter but the Date.IsInCurrentWeek([Date]) is a request filter, what is the filter on your visuals ?

[Evogelpohl]

Thanks for the follow up.  In the pic, you'll note that I'm pulling data from Office365's Usage API - It's just a normal ODATA endpoint - works fine. 

However, for some (not all) of my charts, I never want data from “This Week” or “Last Week” or “Last Month”. Essentially, there are times that the data in those ranges are not complete/finalized yet.

So, in my Get-Data routine, I’m adding a Custom Column and using a few of these M-functions to identify what rows of data fall in these periods:

- Date.IsInCurrentWeek(Date) - Returns T or F

- Date.IsInPreviousMonth(Date) - Returns T or F.

That works as designed.  I can then drop that filter into the visual-level filter pane and remove (set to False) rows from This-Week or Last-Month as I see fit.

Problem:  When you publish to PowerBi.Com and perform a refresh, you no longer see any values that have used these filters. The graphs disappear, but that data are there. It’s the filter that’s preventing it from showing up.

Temp Solution:  If you refresh the data from PBID, then re-publish, they return.  But.. try to refresh again, and you get nothing again.

Yes, this isn’t a refresh issue. Refreshing is fine. I’m having some glitch on PowerBI.com that won’t acknowledge these visual-level-filters after a refresh.