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 R...
Need Help
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.

    • AgataJ's avatar
      AgataJ
      Helper II
      3 years ago

      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.