Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Set TODAY as default date in slicer visual (date range)

Hello, I want my date range (slicer) to dynamically set the date range from the first date value in the dataset to the current date (i.e. today's date).  We have some target values for future date...
Tips and Tricks
  • v-yulgu-msft's avatar
    v-yulgu-msft
    7 years ago

    Hi Anonymous,

     

    Currently, it is not supported to set default values for slicer. Here is an idea, you could click to vote it up. 

     

    Best regards,

    Yuliana Gu

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi LivioLanzo,

What exactly would you need? 

Thanks!

LivioLanzo's avatar
LivioLanzo
Icon for Solution Sage rankSolution Sage
7 years ago

An example of your tables and how they are related

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi LivioLanzo,

    I am pulling up data in Power BI for this table (let's call it Inventory Table) from our DW using a stored procedure. The Inventory Table has the Actuals Value (current value) & Target Value (targets that we need to meet) & a date column. 

    The date column is updated in the DW everytime an Actual or Target value is set.

     

    The Actuals column has values upto the current date (today's date) and is 0 for future dates. While the Targets value has values for the future dates as well.  That is why my slicer range ends at the last value of my Target value (as shown in the image above, 12/1/2018).

    I just need to create a visual for Actuals vs Target & provide a date slicer (range) where the end value of the slicer is the current date (today's date).

    I hope this helps!