Dynamic Timestamp Visualization

[ruidi1126]

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 1	Date 2	Date 3	Date 4	Date 5

Thanks,

Rui

[Anonymous · Accepted solution]

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.