Slicer

[sarjensystems1]

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

[Anonymous]

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.

[Icey]

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.