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 if I want to extract

1. " Quarter to Date " 

2. or Last 3 months(Complete) along with  Current month to date or current month. I am not able to do that.

 

I understand I can create custom slicers using static table entries and measures but I was hoping for an easier way which can replicate almost everything that can be achieved in Tableau.

 

   

Need Help

3 Replies

  • 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