Forum Discussion
Helper IILine Graph roll up by day
Hi MrMike ,
Here is my test table. I add a row as you said.
Then I tried the same steps.
Result:
Can you share some screenshots around the issue please? This is not helping much.
Add error screenshot as well which you are facing.
Hope that's what you were looking for.
Best Regards,
Yuna
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Community ChampionWith a more complex model, I would always say 'use a separate date table' but here it's more straightforward as presented.
To make a date column : In Power Query, duplicate the datetime column and then change the type of the new column to Date.
Close and Apply.
In a line chart visual, put the new date column on the Axis, Put the Event in the Legend and put Event in the Values section (make it a Count). In the format section, make sure the x-axis is categorical.
I'm assuming the Event column is separate from the User column.
MrMikeLooks better but the Event is actually a DAX expression and it is showing a number 1 for each event. For example "Login" event type on 1/26/2021 has two users with login event. The line graph shows a 1 between 5:00 AM and 6:00 AM and then there is another 1 between 6:00 AM and 7:00 AM.
How do I get a 2 over 1/26/2021, so it is summing the whole day?
Login = CALCULATE(COUNT(ACTIVITY_LOG[USER_ID]), ACTIVITY_LOG[ACTIVITY_DESCRIPTION] = "Login")