Spend range is being calculated on a monthly level 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-qiuyu-msft]

Hi @ap241980,

Can you share some sample data and clarify the desired results? 

Best Regards,
Qiuyun Yu