Power BI how to change data shown on y-axix from count to actual data

[Annahita]

Hi there, I am a beginner in Power BI and trying to create a simple bar chart to show year (on x-axix) vs interest rates(decimal numbers) on y-axix.  I have changed the data type for interest rates to decimals, chose 'don't summerize', but when I create the chart the interest rates show as 'count of interest rates' which is not what I want.  can anybody help please? thanks

  here is a picture of what I have now:

[Jai-Rathinavel · Accepted solution]

@Annahita There are two approaches

1. Click on the visual and on the right you can change the aggregation from Count to Sum instead. 

2. Other way of doing it is creating a measure like below and adding it to the Y-axis field

MyMeasure = SUM(YourTable[Interest Rates])

Did I answer your question ? Please mark this post as a solution.

Thanks,

Jai

[Annahita]

Hi Jai, thank you for your reply. Actually I don't want to sum up the interest rates, although I followed your direction (first option), and changed it to Average, which makes more sense in my case. The interest rates I have are daily bases for several years, so I am not sure how this average is calculated and how accurate it is (if my explanation makes any sense at all). Thank again

[Jai-Rathinavel]

@Annahita To have more control over the logics. You have to create a measure

Average Interest = AVERAGE(Table[Interest Rate])

Now filter the data for few datapoints and calculate the average manually and cross check the value with a measure. This is how you can debug the measure.

Thanks,

Jai

[Annahita]

This is a great tip for debuggiing, thanks!