Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

how to hide Future dates

Hi Floks, Hope you are doing good. I Work for IT service reporting where i need to show how the Incident has impacted throughout the year. We track the availability of Incidents. If there is no In...
Need Help
AlB's avatar
AlB
Icon for Community Champion rankCommunity Champion
7 years ago

Hi Anonymous

 

Have you tried the visual level filter? You can there filter out anything above March 2019 (on the field that has the date in your model).

Another option would be to embed this in your measure:

 

 

NewMeasure =
VAR _Res = [YourCurrentMeasureCode]
VAR _LastDate2Show = EOMONTH ( TODAY (), 0 )
RETURN
    IF ( MAX ( 'Date'[Date] ) <= __LastDate2Show, _Res ) //Return blank if beyond the last date to show  
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi AlB ,

 

Thanks for your responce, unforunatly i have given that, if it is blank then give me 100%, so its giving 100% for future data as well.

 

And also i am not able to do visual filter as its not showing future dates at all in my date table.