Forum Discussion

sarjensystems1's avatar
sarjensystems1
Helper 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 dates..(remaining dates i.e from 19-sep should be disabled in the slicer)

 

Thanks

 

Need Help

2 Replies

  • Icey's avatar
    Icey
    Community Support
    6 years ago

    Hi sarjensystems1 ,

     

    It is not suported currently for Power BI. You can change the date range by sliding the slider below the date.

     

    Best Regards,

    Icey

     

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

  • 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.