Date slicer with percent reader.

[matrix_user]

Hi Power Bi users,

What woudl be the best way to buld a card visual that would read out the percentage of the date slicer. 

The challenge would be that scrolling from either end reads the percentage: If you mover the left slicer dot to the right a quarter of the way, you get 75% reading and if you move the right slicer dot, a quarter to the right ,you get a 50% reading for the whole date range.

Thank you people.

[matrix_user]

Thanks Tamerj1

[tamerj1 · Accepted solution]

hi @matrix_user 

you can try

Selected Date Range % =
VAR FirstDateEver =
    CALCULATE ( MIN ( Sales[Order Date] ), REMOVEFILTERS () )
VAR LastDateEver =
    CALCULATE ( MAX ( Sales[Order Date] ), REMOVEFILTERS () )
VAR FirstDateInFiltet =
    MIN ( Sales[Order Date] )
VAR LastDateInFiltet =
    MAX ( Sales[Order Date] )
RETURN
    DIVIDE (
        DATEDIFF ( FirstDateInFiltet, LastDateInFiltet, DAY ),
        DATEDIFF ( FirstDateEver, LastDateEver, DAY ),
        0
    )

But you have to know that if you have dates without sale then the calculated percentage might not be accurate for some selections.  Best is to have a date table.