Count (MAX datetime group by user) by dates

Question

Hello, I have visual table with user activity in Power BI where I have two columns "User Name" and "Last activity datetime" (MAX datetime group by user) sorted by "Last activity datetime". I need linear diagramm on same page which count (MAX datetime group by user) by dates.
For example for this data:
"User Name":"Last activity datetime"
User1:24.06.2021 01:32
User2:24.06.2021 01:00
User3:23.06.2021 01:00
I need this linear diagramm:
24.06.2021:2
23.06.2021:1
and order column for first table as:
1:User1:24.06.2021 01:32
2:User2:24.06.2021 01:00
3:User3:23.06.2021 01:00
Kind regards, Vasily Zaytsev

Answer 1

Excel 365 Pro Plus with Power Pivot and Power Query.
Max DateTime group by user.
With TimeLine and PivotChart.
https://www.mediafire.com/file/28dcts5rk9nqxt5/06_26_21.xlsx/file
https://www.mediafire.com/file/os44hjait1nazrs/06_26_21.pdf/file