Column charts with Count values only (No sum/avg etc)

[Anonymous]

Hi Experts,

This may be a childish question as I am one week new to PBI. But I searched alot before posting message here.

Data Table : "Nominations". This is loaded in Power BI DataSet.

Columns in Nominations table are "EmployeeName", "LikeCount", "CommentCount".

Sample data....

EmployeeName	LikeCount	CommentCount
Mr XYZ	10	4
Mr ABC	6	3
Mis PQR	8	8

Solution: I created clustered column chart with EmployeeName as "X" axis and LikeCount & CommentCount as values. 

Problem: Rather the graph should show length of bars as per count values, PBI is aggregating count values to 1 in the bar.

Looking for any experts comment/solution on this - how to remove the summeraziation.

Note: I have tried Modeling option where Data category is "UnCategorized" and Default Summarization is "Don't Summarize"   

[Greg_Deckler · Accepted solution]

Tough to say, my guess is that your LikeCount and CommentCount are Text for some reason and not numeric. See PBIX attached, you want Table2 and Page2