Forum Discussion
Values Field becomes "Count Of" automatically
Ok you are right, I didn't understand you correctly.
If I am there now and you want to put on Y axis unaggregated, data then we don't have this functionality .
If X-axis values are in row granularity you can change the type of aggregation to sum/avg/max/min and it is equivalent to row data because of the filter.
If it not the case to avoid wasting time guessing what the need is, so I or others can answer the question,please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523Hi RelationalData As I mentioned aggregation is a must on the graph.
I saw that you have one row for one student in a specific month.
So you can change it from count to average which will give you the desired results:
(like pivot from Excel)
Unfortunately, i am out of my limit of images to add so please download the screenshot from Here
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Hi Ritaf1983
Would you be able to tell me how to attach a .pbix file and Excel file please. I encounter this error message : "The file type (.pbix) is not supported.
This is my expected data :
This is my current project which produces this incorrect results:
Thanks you.
- Ritaf1983
Super User
RelationalData
Of course, save it in one drive and share the link, like I shared my sample on the first reply