How to filter visual by today.

[Amardeep100115]

Hi 

i would like to filter data/ visual by today coloun in data, it means visual shoud display data for upcoming lease expiry by lease expire year by quarter, which due in next 6 month , 12 month, next Year. 

i have shown in visulised table in attached file, but i am unable to filter it by today for upcoming expiring lesae.

Also if there is not value is selected in slicer then the visual should be display currunt month data.

I have used below measures to achive that.

i have filtered corrumnt month by below 2 measures: (i dont want to disrurb those measures)

1)

TotalSites = COUNT(ValidFacilities[SAP Bldg ID])

2) 

Total Sites = IF(HASONEVALUE(ValidFacilities[Mnth_Yr]),[TotalSites],COUNTAX(FILTER(ValidFacilities,ValidFacilities[Mnth_Yr]="September_2019"),[TotalSites]))

https://1drv.ms/u/s!Ai3rGPgy20kLyjbCcWBLCwjIZFKk?e=CeWJyM

Hope i am clear in my results 

[Icey]

Hi @Amardeep100115 ,

Try this: Use a relative date slicer and filter in Power BI Desktop.

Best Regards,
Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Amardeep100115]

I already checked this actually but what i am looking is that i wish  to filter data/visual after today's date so automatically  it will be filter quarter as well