How can I only separately show the values of the files in the Charts without...

[BigRig16]

Maybe this post has already been created and if so, I apologise as I did not see it.

I am currently trying to show my files on a PowerPivot Chart and show the individual values for each file per day. Unfortunately, it keeps showing me the sum of all the files per day. Is there anyway that I can do this and if so how? My team would enjoy to see a visual representation of all the files and there separate values per day in a weekly chart. For example using a standard Bar Chart, if there are 6 files a day (there would be 6 bars with separate values) and a display of the 7 days in a week showing separate values making a total of 42 bars. In my case, I get 7 bars showing a total of all the values per day and only 7 bars.

I welcome any and all attempts to help me work through this if it is possible.

Thanks in advance!

 

[MD610]

Do you have the filename or some other unique ID for the files placed in the Axis field of your pivotchart?

You should have Days and filename in your Axis and then your would see 42 bars (or whatever the actual number is).