Spend range is being calculated per month instead of over entire year

[ap241980]

Hello,

We want to display the number of suppliers that fall within a certain spend range over the period selected via timeline slider. Below shows a chart for Apr - Mar financial year with suppliers per spend range 

https://ibb.co/mLTZLm

However the values are inflated because power bi is calculating the number of suppliers at a monthly level. So if say there were 100 unique suppliers in month one and 10 unique in month 2 etc, it's summing those can't per range. What we would like is to calculated the number of suppliers per spend range over the entire period (in this case one year). Any help would be appreciated.

[v-sihou-msft · Accepted solution]

@ap241980

In this scenario, you already put the "bucket" field on X-axis. If you need to split the data into monthly level, you can only put month field on Legend so that it will show monthly data under each bucket. 

Regards,