Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I am a new user that is familair with excel and new to BI. I am trying to create a visualization (chart) that displays the average number of sheets that each user can complete per day. There are days that a user will not complete any sheets (I document the day that each sheet was completed).
I have the following columns (user, sheet #, date completed).
Any suggestions on creating a bar graph with this data?
Solved! Go to Solution.
Hi @telecom,
If you 'sheet #' column stored the numeric value, you can direct create bar chart : 'date completed' to axis fields, 'sheet #' to value field and switch summary mode to average.(click on triangle icon to open the quick operation menu)
Regards,
Xiaoxin Sheng
Hi @telecom,
If you 'sheet #' column stored the numeric value, you can direct create bar chart : 'date completed' to axis fields, 'sheet #' to value field and switch summary mode to average.(click on triangle icon to open the quick operation menu)
Regards,
Xiaoxin Sheng
Hi @telecom,
Perhaps the following is an idea:
A date slicer where you can select the date; A slicer where you can select a User (this is optional if you have alot of users for example)
Beneath it a bar chart where the X axis is "User" and the Y axis is an average of the "Sheet#"
AVERAGE(Table1[Sheet#])
in this approach you focus on "User" you can also use "Date completed" as X axis for example then and average sheets completed. That way you focus more on the date, but note that you can get an insanely wide chart when you do this.
Let me know what you think about it, or if you need help.
Regards,
L.Meijdam
User | Count |
---|---|
128 | |
108 | |
100 | |
64 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |