Create a Custom single date picker which gives the option to select a range of dates

[sidd88]

Hi,

is there any way to create a custom date picker , with a range selection.

note: not using the power viz custom date picker visual

[Anonymous]

Hi @sidd88 ,

Creating a date table and three measure does the trick:

DateTable = 
ADDCOLUMNS (
    CALENDAR (DATE(2023, 1, 1), DATE(2024, 12, 31)),
    "Year", YEAR([Date]),
    "Month", MONTH([Date]),
    "Day", DAY([Date])
)

SelectedStartDate = MIN('DateTable'[Date])

SelectedEndDate = MAX('DateTable'[Date])

FilteredData = 
CALCULATE (
    SUM('Sales'[SalesAmount]),
    FILTER (
        'Sales',
        'Sales'[Date] >= [SelectedStartDate] &&
        'Sales'[Date] <= [SelectedEndDate]
    )
)

Hope it helps!

Best regards,
Community Support Team_ Scott Chang

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

[sidd88]

@amitchandak  Thank you for your suggestion but this custom visual thing i have already explored and it needs license, is there any way we can replicate this thing without using a custom visual

[amitchandak]

@sidd88 ,refer if this can help

https://appsource.microsoft.com/en-us/product/power-bi-visuals/truvizinc1674781244292.date-picker-by...

more

https://appsource.microsoft.com/en-us/marketplace/apps?search=date&page=1

Or you have to consider custom visual development