Forum Discussion

AgataJ's avatar
AgataJ
Helper II
3 years ago

Relative date

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

 

 

 

 

 

 

 

 

 

 

Need Help

4 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    3 years ago

    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's avatar
      AgataJ
      Helper II
      3 years ago

      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's avatar
        amitchandak
        Super User
        3 years ago

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