Forum Discussion

Gresi's avatar
Gresi
Frequent Visitor
7 years ago
Solved

select a time period between two dates with time

Hi at all,

 

i'm new to power bi and i'm looking for a visual to select a period between two dates within the time.

Like that:

 

I'd like to have two of these, one for startdate and one for enddate.

 

After the selection of startdate and enddate i want do show all the entries from this table between these dates in a timeline.

 

Maybe someone can help me,

 

thx Gresi

Need Help
  • v-xicai's avatar
    v-xicai
    7 years ago

    Hi Gresi ,

     

    It is not supported to implement your demand in Power BI currently .There is an idea about this issue, please vote it up, https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/31594630-datetime-slicer, to improve the Power BI.

     

    It is a place for customers provide feedback about Microsoft Office products . What’s more, if a feedback is high voted there by other customers, it will be promising that Microsoft Product Team will take it into consideration when designing the next version in the future.

     

    We also submitted this feedback to the product group internally, so that the product group can pay attention to this problem and speed up the issue repairing.

     

    Best Regards,

    Amy

     

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

3 Replies

  • v-xicai's avatar
    v-xicai
    Icon for Community Support rankCommunity Support
    7 years ago

      

    Hi Gresi ,

     

    You can choose Slicer visual to display the date column, select "Between" , "Before" or "After" format.

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

    Best Regards,

    Amy

     

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

    • Gresi's avatar
      Gresi
      Frequent Visitor
      7 years ago

      Hi Amy,

       

      thanks for answering.

      The slicer visual only allows selecting dates.

      I need to adjust starttime and endtime too.

       

      For example:

       

      adjusted startdate -> 01.08.2019

      adjusted starttime -> 00:30:25

       

      adjusted enddate -> 03.08.2019

      adjusted endtime -> 14:30:00

       

      Now i want all entries from a table where entrie-starttime is between 01.08.2019 00:30:25 - 03.08.2019 14:30:00.

      I hope you understand.

       

      Best Regards,

       

      Gresi

       

      • v-xicai's avatar
        v-xicai
        Icon for Community Support rankCommunity Support
        7 years ago

        Hi Gresi ,

         

        It is not supported to implement your demand in Power BI currently .There is an idea about this issue, please vote it up, https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/31594630-datetime-slicer, to improve the Power BI.

         

        It is a place for customers provide feedback about Microsoft Office products . What’s more, if a feedback is high voted there by other customers, it will be promising that Microsoft Product Team will take it into consideration when designing the next version in the future.

         

        We also submitted this feedback to the product group internally, so that the product group can pay attention to this problem and speed up the issue repairing.

         

        Best Regards,

        Amy

         

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