This is probably really easy but I can't work it out.
I have a table with a user id and a log in time.
I want to show the count of users who have logged in x number of times.
So I'd have 1,2,3 etc on the x axis and the count of users on the y axis.
Any help appreciated - thanks.
Solved! Go to Solution.
I recreated your problem, and the pictures below show how to get the visualisation you want.
(used a column chart)
(User ID are numbers in my example 1-7)
Hope this was what you wanted to know.
let me know if you have questions !
Thanks - but this isn't quite what I want. I don't want to see individual user ids. I want to see the count of userids over the count of logintimes.
So. If I have the following:
User - Login Time
1 - 10.00
2 - 11.00
3 - 12.00
4 - 13.00
5 - 14.00
6 - 15.00
1 - 16.00
2 - 17.00
3 - 18.00
1 - 19.00
2 - 20.00
1 - 19.00
The graph would show the count of logins in the x axis (1,2,3,4) and the count of users who have logged in that many times on the y axis (3,1,1,1).
You may follow the steps below.
1) add a calculated table
Table2 = GENERATESERIES ( 1, 4, 1 )
2) add a measure
Measure = COUNTROWS ( FILTER ( SUMMARIZE ( Table1, Table1[User], "Count", COUNTROWS ( Table1 ) ), [Count] = MAX ( Table2[Value] ) ) )
Small question: If the count of logging changes, let's say a user have logged in 20 time, does that mean Generateseries() formula needs to be updated?
Check out new user group experience and if you are a leader please create your group
Click here to read more about the March 2021 Updates!
100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.
See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.