Date range slider does not show appropriate dates

[#1]

Dear all,

I work on the attached file which should basically be a slider which allows you to select dates. And then only the relevant data should pop up in the bar chart. It all seems to work however the two selection sliders only allow me to

Any thoughts on what goes wrong here>?

[Anil_Babu_Samineni]

Marc, Can you please let me know

LOAD * INLINE [

    Country, Value, Salesdata

    USA, 12, 2013-01-04

    USA, 14, 2013-02-05

    USA, 14, 2013-02-05

    USA, 14, 2013-02-06

    USA, 14, 2013-02-07

];

let vFromDate = Floor(Date#('2013-01-01', 'YYYY-MM-DD'));

let vToDate = Floor(Date#('2013-06-30', 'YYYY-MM-DD'));

In that Variables you used the 01-01-2013 and 30-06-2013

But, In your data you don't have Data. How do you Achieve that

Selecting Arbitrary Date Ranges - YouTube

[r3iuk]

2 Options depending on what kind of date select control you want to use.

1. If as in your example you want 2 calendar controls, then in each control set the following:

Min Value:  =min(Salesdata)

Max Value: =max(Salesdata)

2. If you want a single Slider control then set its field to Salesdata, and in Multi Value mode.  Then in your chart, the expression just needs to be Sum(Value)

[trdandamudi · Accepted solution]

Please see the attached file and modify according to your needs. In this app based on your requirement you can select the dates from 2013-01-01 to 2013-06-30. Hope this helps..