Forum Discussion
Auto disappear from table visual after contract end date
Hi,
Request your guidance regarding this issue;
I have a table visual in which contract end date of employees are displayed. one column ( contenddate) shows the last working day of employee in date format . Next to that is a column ( status) which displays whether it is terminated/resigned/retired . For these three cases once the last working day is over ( say 10th August 2022) then this record should not be displayed in the visual. is there any way to make this happen. ( i dont want to make any change in the database - xls table )
kindly advice
regards,
dsmitha
Hi Anonymous ,
According to your description, in my understanding you want the contract end date which is over not display in the visual, you can create a measure.
Check = IF ( MAX ( 'Table'[Contract end date] ) > TODAY (), 1, 0 )Then put the measure in the visual filter and select its value to 1.
After apply filter, get the correct result, the date(2022/8/10) is filtered out.
I attach my sample below for your reference.
Best Regards,
Community Support Team _ kalyjIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
4 Replies
v-yanjiang-msftCommunity Support
Hi Anonymous ,
According to your description, in my understanding you want the contract end date which is over not display in the visual, you can create a measure.
Check = IF ( MAX ( 'Table'[Contract end date] ) > TODAY (), 1, 0 )Then put the measure in the visual filter and select its value to 1.
After apply filter, get the correct result, the date(2022/8/10) is filtered out.
I attach my sample below for your reference.
Best Regards,
Community Support Team _ kalyjIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- rsbin
Community Champion
Anonymous ,
Select your Table Visual.
Then in the Filter Pane, under "Status", deselect the 3 values ( terminated/resigned/retired ) that you do not want to show up.
- Hi rsbin,Thank you for your suggestion but am afraid that i didnt make it clear in my request . Instead of applying the filter I would like to make this happen with a DAX . Contract end date of employees are different so whenever the date today = contract end date then that record should not be displayedregards,dsmitha
