Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

dynamic default value date slicer

Hi,  I have read many posts about dynamic default value date slicer, and it seems like it is not possible (yet). I have a report with a facts table that includes a date column and the table refreshes...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

az38  and Anand24 Tnx for reply,

Its a dropdown date slicer.
The table refreshes every day and only contains the current and future dates and values.
The dropdown dateslicer have to be dynamic selecting only the current date as default every single day.

mahoneypat's avatar
mahoneypat
Icon for Microsoft Employee rankMicrosoft Employee
6 years ago

If the columns used in the slicer only has values from Today forward, if you enable Single Select on the dropdown slicer options, it will default to the min value (Today).

 

Alternatively, you can use a Relative Filter on the visual and choose "In the Next X days" and check the box that says Show Today.

 

If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

Regards,

Pat

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    mahoneypat , 

    Both alternatives will not work or does not fit my requirement. When open the report in service or desktop the dateslicer still shows the date of the last time the report is saved and published. Clicking on the arrow to select the dates does show all the available dates in the date column.
    For my recruirements I need the date slicer selecting AND Showing the current date/first date available in the table.