Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

Need help with creating a graph

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...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    Hi Anonymous,

     

    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

     

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi Anonymous,

 

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