Forum Discussion

pareke03's avatar
pareke03
Frequent Visitor
4 years ago

Date filter for previous month

Hi Experts,

 

I have a report that tracks sales performance of the company every day. I have set a relative date filter on my report that filters data for current month which is refreshed automatically on PowerBI service. The data is being pulled every day at 8am for the MTD shipping activity for prior day. Due to this filter we loose visibility of shipping activity of last date of the month (and full month) because on the first date of next month data is being filtered for that month. How can I put a dynamic date filter so that on first date of each month we can still see full view of previous month? Unfortunately I can't put a slicer for month as it won't support my current setup.

 

Appreciate your time and ideas.

 

Best,

Keyur Parekh

 

1 Reply

  • v-kelly-msft's avatar
    v-kelly-msft
    Icon for Community Support rankCommunity Support

    Hi  pareke03 ,

     

    Sorry I'm a little confused with your requirement,could you pls provide some sample data with expected output for test?

     

    Best Regards,
    Kelly

    Did I answer your question? Mark my reply as a solution!