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

[Vivek26]

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.

[v-easonf-msft]

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]

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]

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