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 numb...
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.

     

     

     

     

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.