Forum Discussion

ruidi1126's avatar
ruidi1126
Frequent Visitor
2 years ago
Solved

Dynamic Timestamp Visualization

Hi,

 

In my raw data, I have a few timestamps from a process as below. Is there any visualization in Power BI that allows a user to pick any two date points and the visualization will show the number of dates spent between the two points?

 

Date 1Date 2Date 3Date 4 Date 5
     
     
     

 

Thanks,

Rui

Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi ruidi1126

     

    For your question, here is the method I provided:

     

    Here's some dummy data

     

    "Table"

     

    You can select any two dates by creating a Vertical List slice.

     

     

     

     

    You can calculate the number of days between selected dates by creating a measure.

     

    Date Interval = 
var _mindate = MIN('Table'[Date])
var _maxdate = MAX('Table'[Date])
RETURN IF(ISFILTERED('Table'[Date]),DATEDIFF(_mindate, _maxdate, DAY), BLANK())

     

     

    Here is the result.

     

     

    If you're still having problems, provide some dummy data and the desired outcome. It is best presented in the form of a table.

     

    Regards,

    Nono Chen

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

     

     

     

     

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi ruidi1126

     

    For your question, here is the method I provided:

     

    Here's some dummy data

     

    "Table"

     

    You can select any two dates by creating a Vertical List slice.

     

     

     

     

    You can calculate the number of days between selected dates by creating a measure.

     

    Date Interval = 
var _mindate = MIN('Table'[Date])
var _maxdate = MAX('Table'[Date])
RETURN IF(ISFILTERED('Table'[Date]),DATEDIFF(_mindate, _maxdate, DAY), BLANK())

     

     

    Here is the result.

     

     

    If you're still having problems, provide some dummy data and the desired outcome. It is best presented in the form of a table.

     

    Regards,

    Nono Chen

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