cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ap241980 Frequent Visitor
Frequent Visitor

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

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.

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Moderator v-sihou-msft
Moderator

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

@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,

1 REPLY 1
Moderator v-sihou-msft
Moderator

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

@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,