Relative date

[AgataJ]

Good morning Power BI community,

I have an issue with last 30 days relative date filter.

I have a simple column chart that shows BD avg in the last 30 days. 

Master Calendar  - Date - X axis

Receipt - BD Avg - Y axis

Relationships: Master Calendar 1:* Receipt.

BD Avg is a measure

"BD Avg = CALCULATE(AVERAGE(Receipt[BD]),USERELATIONSHIP(Receipt[Post Date],CalendarMaster[Date]))"

Everything was working properly till last week, and now I cannot filter the date by last 30 days as the chart is blank then. When I try to filter by last 3 months it is ok though. 

I haven't change anything in the relationship or made any other changes.

 This is the original visual:

Here is what I can see now:

And here is now without any date filter, looks ok till I want to filter it.

I have spent lots of time trying to fix it by google search of similar issues, but still don't have the answer.

I would appreaciate any piece of advice on it.

Reagrds,

Agata

[amitchandak]

@AgataJ , first of all, check do you have data in fact/s for the last 30 days. In case you are using date table, does date table has dates for last 30 days

[AgataJ]

Hi @amitchandak , thank you for your time and reply.

I have just checked both tables, Master Calendar has dates in the last 30 days, Receipt table has orders in the last 30 days as well.

Kind regards,

Agata

[amitchandak]

@AgataJ
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[AgataJ]

Hi @amitchandak 

I started to prepare the file to send it here, I was removing slicers and it turned out all data showed back when I removed one of the slicers. So i think the issue is here, now I need to review it.

Thank you very much for your time, without your question about sending data I would not get to it 🙂

A.