Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

How to filter visual by today.

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 

Need Help

2 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      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