Percentage from column in clustered chart

Question

Hi there,&nbsp;I need to have a clustered chart that displays 100% of the values per country.Currently 100% is being distributed by all countries across all buckets ( Ihave selected "Percentage from Total")&nbsp;&nbsp;i.e. In the below screenshot I would like to see a country like UK to have 20% on each bucket (1,2,3,4,5) to complete 100% per country.Does someone know how to fix this?&nbsp;Thanks

arentir · Answer

Hi&nbsp;Anonymous, can you share the file with us?&nbsp;&nbsp;

anonymous · Answer

Hi&nbsp;Arentir,&nbsp;Here is the pbix.&nbsp;Thanks

arentir · Answer

Hi&nbsp;Anonymous,&nbsp;Can you tell me what is the calculation about? The count of row in table by bucket?&nbsp;If so for UK you would like to achieve this result in the graph?&nbsp;

anonymous · Answer

Hi&nbsp;ArentirSorry, that was actually only a sample but I think I forgot to give some context.Let's say that the bucket is distribution placements.i.e:Bucket 1: case responded within 1hrBucket 2: case responded over 1hr and below 2hrBucket 3: case responded Over 2 hr and below 3hrand so on..See here an example of the data I have:Month | Name | Country | Bucket | Avg Time of response ( I have all of these variables and more, but I think these are the only ones relevant)March - Jake - UK - 4 - 4.27March - Lori - USA - 2 - 2.10March - Stephen - UK - 2 - 2.20April - Jake - UK - 3 - 3.39April - Lori - USA - 3 - 4.8Here, this is the output I am looking for:(Filter by March)UK - Bucket 4 - 50%UK - Bucket 2 - 50%Totaling 100% per country in March--If I were to click on Bucket 4, then I would see on a syncronized table with the "Name" field and "Avg Time of Response" as "Jake | 4.27".This is what I have right now:REP%Distinc = COUNTA('SolvedCasesData (3)'[Bucket])/CALCULATE(COUNTA('SolvedCasesData (3)'[Bucket]),ALLNOBLANKROW('SolvedCasesData (3)'[Bucket]))I also want to be able to manipulate the data by adding/removing more months or filtering by certain countries.At the moment I am seeing the same people showing on different buckets on the same chart when I select multiple months and they show different hours.I am guessing that somehow I am not calculating the average of the ''names'' when selecting multiple ''months''.So if I select March and April, Lori will have 2 different buckets. But What I really need is to calculate the average of their response time and then assign to a bucket.I have this formula in an excel to calculate the buckets, maybe this is the thing causing issues and it should be on power bi for dynamic calculation?=IF(J11&lt;3.59,1,IF(AND(J11&gt;=3.6,J11&lt;=4.49),2,IF(AND(J11&gt;=4.5,J11&lt;=5.39),3,IF(AND(J11&gt;=5.4,J11&lt;=6.29),4,IF(J11&gt;=6.3,5,)))))&nbsp;Basically what the above does is to check the J column that has the "Avg time of response" and then puts each line into a bucket on a different row. I have imported the excel from power bi and this is the data I was working on.Any help would be much appreciated!&nbsp;Thanks

anonymous · Answer

Hi&nbsp;Arentir,&nbsp;Here is the new pbix, hope you can help!&nbsp;Thanks

Forum Discussion

Percentage from column in clustered chart

6 Replies

Related content

Clustered column chart incomplete legend

Clustered column chart (percentage)

Need a stacked clustered column chart

Percentage in clustered column chart visual

Percentage Column