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

custom bins

I know this has been asked before, and the answer seemed to be no.  However that was a while ago...

 

With SLAs it's common that there are various targets to be hit - done on the due day, 2 days later, 5 days later 10 days later and so on.  I'd like to be able to colour a stacked bar chart accoding to whatever the SLA defines these numbers of days as.  Unfortunately they are almost never even.  This is an example I've done choosing the bin size myself, it's test data so a little cruddy but I think you can see what I want to do.  On this data there should be one bin for less than zero, another for zero, another for 1-3, another for 4-10 and the last one for over 10.

 

Capture.PNG

1 ACCEPTED SOLUTION

This article seems to do what you want...  They were concerned about the order, but you can do the same thing to 'bypass' the Legend with your own custom Measures ordered correctly in the Values column...

 

https://community.powerbi.com/t5/Desktop/Rearrange-Pies-in-Pie-Chart/m-p/25218#U25218

 

 

Done Early = CALCULATE(COUNT(Table2[days_over_target]), FILTER(Table2,Table2[days_over_target] > 0))

On Time = CALCULATE(COUNT(Table2[days_over_target]), FILTER(Table2,Table2[days_over_target] = 0))

1-3 Days Late = CALCULATE(COUNT(Table2[days_over_target]), FILTER(Table2,Table2[days_over_target] < 0 && Table2[days_over_target] >= -3))

4-10 Days Late = CALCULATE(COUNT(Table2[days_over_target]), FILTER(Table2,Table2[days_over_target] < -3 && Table2[days_over_target] >= -10))

Over 10 Days Late = CALCULATE(COUNT(Table2[days_over_target]), FILTER(Table2,Table2[days_over_target] < -10 ))

 

 

Capture.PNG




Did I answer your question, or help you along the way?
Please give Kudos or Mark as a Solution!


https://www.linkedin.com/in/forrest-hill-04480730/

Proud to be a Super User helping give back to the community!
Thank You!




View solution in original post

5 REPLIES 5
fhill
Resident Rockstar
Resident Rockstar

Can you copy & paste some sample data please?




Did I answer your question, or help you along the way?
Please give Kudos or Mark as a Solution!


https://www.linkedin.com/in/forrest-hill-04480730/

Proud to be a Super User helping give back to the community!
Thank You!




Here you go.

 

visit_id,play_area_id,days_over_target
2,2,-1
734,2,-13
3,3,1
4,4,1
7,7,-4
9,9,-4
15,15,-2
763,15,-2
16,16,0
29,31,0
528,31,-5
30,32,1
559,32,-5
33,35,-1
525,35,-5
35,37,0
545,37,-5
36,38,0
550,38,-5
37,39,0
511,39,-5
38,40,0
504,40,-5
39,41,0
505,41,-5
40,42,0
495,42,-5
41,43,0
497,43,-5
43,46,-1
598,46,-1
1058,46,0
1059,46,0
50,53,-4
1078,53,0
51,54,-4
1029,54,4
52,55,-4
1028,55,3
56,59,-5
57,61,-5
1026,61,3
1064,61,0
1096,61,0
1098,61,-1
59,63,-5
750,63,-2
1070,63,-21
60,64,-5
62,66,-4
766,66,-2
63,67,-4
1027,67,4
68,73,-4
70,75,-2
1097,75,0
1099,75,-42
71,76,-2
76,81,-2
77,82,-2
79,84,-2
864,84,-3
80,85,1
1062,85,0
1063,85,0
82,88,2
83,89,2
86,94,2
88,98,1
89,99,1
90,100,1
93,103,0
96,107,-1

This article seems to do what you want...  They were concerned about the order, but you can do the same thing to 'bypass' the Legend with your own custom Measures ordered correctly in the Values column...

 

https://community.powerbi.com/t5/Desktop/Rearrange-Pies-in-Pie-Chart/m-p/25218#U25218

 

 

Done Early = CALCULATE(COUNT(Table2[days_over_target]), FILTER(Table2,Table2[days_over_target] > 0))

On Time = CALCULATE(COUNT(Table2[days_over_target]), FILTER(Table2,Table2[days_over_target] = 0))

1-3 Days Late = CALCULATE(COUNT(Table2[days_over_target]), FILTER(Table2,Table2[days_over_target] < 0 && Table2[days_over_target] >= -3))

4-10 Days Late = CALCULATE(COUNT(Table2[days_over_target]), FILTER(Table2,Table2[days_over_target] < -3 && Table2[days_over_target] >= -10))

Over 10 Days Late = CALCULATE(COUNT(Table2[days_over_target]), FILTER(Table2,Table2[days_over_target] < -10 ))

 

 

Capture.PNG




Did I answer your question, or help you along the way?
Please give Kudos or Mark as a Solution!


https://www.linkedin.com/in/forrest-hill-04480730/

Proud to be a Super User helping give back to the community!
Thank You!




Thanks, I will try this out, but probably next week now.

Yes that works, thanks.

Helpful resources

Announcements
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

Thank you 2022 Review

2022 Monthly Feature Releases

We had a great 2022 with a ton of feature releases to help you drive a data culture.