Forum Discussion

sarjensystems1's avatar
sarjensystems1
Icon for Helper III rankHelper III
6 years ago

Slicer

  Hii... I am using slicer visual and i have transaction dates upto 18-sep-19 in my data model.how to restrict the dates in the between format of the slicer only to display the available date...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi,

You can create a calculated column in the Date table as below:

DateToShowFlag = 
VAR vMaxDate = CALCULATE( MAX( Transaction_Data[transaction_date] ), ALL( 'Calendar' ) )
RETURN 
IF( 'Calendar'[date] <= vMaxDate, TRUE(), FALSE() )

You can then put this column in the page level filter and set it to True.

The only catch here is, you will need to have the slider 'ON' for the slicer.

Thanks.