Relative Date Functionality in Power BI:

[Anonymous]

Hi Team,

Issue#1 

Need to know is there any way to implement the below relative date filter functionality in Power BI

Please note the following:

For year the base year should be current year, for now it should be 2021

For month the base month should be current month, for now it should be july and so on.

Issue#2:

Based on the above, we want to implement a functionality based on the below selection, where in if we select week, then we should see the count of a metric only for the weeks which are passed by the above filters and similarly for months, days etc. For eg, if we select year, then we should get the count for the year 2022 only as this is the only year passed by the above filter.

Thanks for any help!

[amitchandak]

@Anonymous , If a relative date slicer can not work for you, you have to create this with one or more slicers and implement it using an independent date table.

relative date slicer -https://docs.microsoft.com/en-us/power-bi/visuals/desktop-slicer-filter-date-range

Refer to my video, where I made small attempt

refer

Need of an Independent Date Table:https://www.youtube.com/watch?v=44fGGmg9fHI

or this

https://community.powerbi.com/t5/Desktop/Required-custom-date-Slicer-Last-7-days-last-15-days-last-30/m-p/1284966#M561629