How to get rid of automatically count in POWER BI?

[meet_01]

When i add a column that contains decimal numbers in values and Month & Year in Axis it automatically showing Count not the Decimal numbers i want to show in the Line chart.

Please help me in this problem.

Thank you. 
Meet

[v-yanjiang-msft]

Hi @meet_01 ,

Has your problem been solved by @AntonioM 's suggestion, if yes, please consider accept it as the solution to help the other members find it more quickly.

Best Regards,
Community Support Team _ kalyj

[AntonioM]

Currently you only have one line, so it will only show one (aggregated) value for each month.

I'm guessing from the screenshot of the data that you're looking to have a different line for each employee? If that is the case then you'll need to add 'Employees Name' into 'Legend'. This will give you one line for each employee, and you'll see all of the points in your 'Work ethics average' column.

Hope that helps.

[Tahreem24]

@meet_01 As that column is numeric column and when you drag it on chart so you need to choose any aggregation functions like Count, SUM etc. Try to use SUM instead of COUNT.

[meet_01]

I just wat the data to show as it is in the chart. I don't want any function like SUM, COUNT etc.

So, how do I do it?

[coskuersanli]

Hi,

You need to create a measure to do that. Can you try below one please.

AVERAGE(work_ethics_average)

[meet_01]

I do not need average of work_ethics. I just want tha data to show in the visuals how they are in column.