How to change 'Count of' to the actual value in Power BI

Question

I've been banging my head against the wall trying to change fields in a column chart from 'Count of' to the actual value. I have verified that data is numbers and not strings/text, I've clicked on 'Don't Summarize' but no luck.

Answer 1

Hello there,

Your fields that you are using are strings, not numeric, thus you only have the count or distinct count option. You need to convert these to numeric (go to the Modeling tab and change the Data Type) and then you can perform aggregations like sum, average, etc. If there is only one value per X axis increment, then these aggregations will return the actual value.

Similar discussion here https://community.powerbi.com/t5/Desktop/The-real-actual-value-not-the-count-of-values/m-p/131483#:\x7e:text=You%20need%20to%20convert%20these,will%20return%20the%20actual%20value

Hope this resolves your Query !!

--If the reply is helpful, please Upvote and Accept it as an answer--