Power BI - Customer Feedback scoring, Agrregate issue in Chart

[Lionel_Charley]

Pls help me on this issue on department scoring

I have department data from year 2011 to 2020. In this scenario I have filtered by year 2014 from my date table and department by “QUAL”.

Scoring criteria is from 1 to 5. 5 means excellent and 1 means Poor. I want to plot each occurrence and always in Y axis it should be max 5. Since I have scoring received for same date in some occasion it is aggregating and giving me total. See data for March 31 2014, we have two scoring received, see ID 114,115. So in that chart it is adding point 5+4 =9. I don’t want that to happen, my chart should show 5 and 4 in x axis. Anyone can help me on this

[Icey · Accepted solution]

Hi @Lionel_Charley ,

This behavior is by designed. This post explains clearly.

It is suggested to create a Scatter chart and put unique key, such as "ID" column, into "Legend" field.

Best regards

Icey

If this post helps, then consider Accepting it as the solution to help other members find it faster.