Count (MAX datetime group by user) by dates

Zaytsev Vasily 201 Reputation points

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:
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

Not Monitored
Not Monitored
Tag not monitored by Microsoft.
36,987 questions
0 comments No comments
{count} votes

Accepted answer
  1. Herbert Seidenberg 1,191 Reputation points

    Excel 365 Pro Plus with Power Pivot and Power Query.
    Max DateTime group by user.
    With TimeLine and PivotChart.

0 additional answers

Sort by: Most helpful