How to present value instead of count/sum in a report?

[Rotemshan]

Hi, 

I'm a newbie in Power Bi but I have a lot of experience in Excel, 

Lately, I decided to move my reports to Power BI and I found it a bit confusing, and I wish you could help me. 

I'm trying to build a report that shows the given score by customers (the value), but instead of the score, I get the count of the responses. 

How can I change that? 

I prepared a demo file, but I don't see any way to attach it

[Rotemshan · Accepted solution]

Hi All, 

I found the issue, it was with the provided data, 

Some of the scores included text for some reason  (Why would they do that??)

See the below screenshot.

I used the split function to keep only the integers and it's working well. 

Thank you all

[Anonymous]

Hi @Rotemshan ,

Add the [Month] to legend field so that the visual could recognize data by months.

Best Regards,

Jay

[Rotemshan]

If we're talking on the same menu, 

I don't have the "Conversion" option 

[Rotemshan]

I need the value of the score,

and if it appears twice, It should be presented twice with the correct values, 

If you take a look at the data, 

Contact, "Name1" has 2 lines where the scores are 7, and 8 

He voted in January and June

[Tahreem24]

@Rotemshan , YOu can change the aggregation by followin the below screen shot: