Forum Discussion

Vivek26's avatar
Vivek26
Icon for Advocate I rankAdvocate I
3 years ago

Replicate Tableau Relative date Filter in powerbi ( Current Month to date and Previous month )

Hi All ,    I am trying to replicate a Tableau Relative Date filter in Powerbi. The standard relative date slicer in Powerbi works great for most scenarios but It doesn't cover a few. For example...
Need Help
v-easonf-msft's avatar
v-easonf-msft
Icon for Community Support rankCommunity Support
3 years ago

Hi, Vivek26 

If you want to exact Last 3 months(Complete) along with  Current month, please try using "Months (Calendar)" instead of "Month" in the relative date slicer.

Best Regards,
Community Support Team _ Eason

 

Vivek26's avatar
Vivek26
Icon for Advocate I rankAdvocate I
3 years ago

Thanks for the reply.

If you notice closely it doesn't include the Initial days of the month, It starts from 14th July.

I want it to start from 1st July till date.

  • v-easonf-msft's avatar
    v-easonf-msft
    Icon for Community Support rankCommunity Support
    3 years ago

    Hi， Vivek26 

    If this is the case, the date period is not really three months.、

    Unfortunately, relative date slicers do not support such data filtering, and you may need to add new measure and create custom slicer.

     

    Best Regards,
    Community Support Team _ Eason