Very interesting approach. I really like it! I have a similar thing i am working on. Instead of age banding, it is price banding. An additional wrinkle to the attached example - I want the maximum price to flex based on additional slicers (Product grouping or Product sku). My Price Integer Max formula is Price Int Max = CALCULATE(MAX(Actuals[Price Int]),ALLSELECTED(Actuals)). My Max Price formula in the Parameter table is Max Price = maxx(Actuals,[Price Int Max]). I am getting the following error in the details Calculation Error in 'How Many Bands'[Qty in Each Band]: GenerateSeries function cannot have an increment value less than or equal to zero. I do not see how this can be as my min is 0, my max is 1,230, number of bands is 10 and Price Band Value is 123.
Great video Reza! Looking forward for the next video based on size!
😊👊
Valuable information. Thanks for all the efforts
Great tutorial, thanks
Impressive video, thank you for sharing!
Very interesting approach. I really like it! I have a similar thing i am working on. Instead of age banding, it is price banding. An additional wrinkle to the attached example - I want the maximum price to flex based on additional slicers (Product grouping or Product sku). My Price Integer Max formula is Price Int Max = CALCULATE(MAX(Actuals[Price Int]),ALLSELECTED(Actuals)). My Max Price formula in the Parameter table is Max Price = maxx(Actuals,[Price Int Max]). I am getting the following error in the details Calculation Error in 'How Many Bands'[Qty in Each Band]: GenerateSeries function cannot have an increment value less than or equal to zero. I do not see how this can be as my min is 0, my max is 1,230, number of bands is 10 and Price Band Value is 123.
I have the exact same issue haha I wonder if you managed to resolve the problem?
Thanks for the video. How would you do that if the value was not discrete as age, but it was a continuous value?
The number of bands you show does not match what is shown in the histogram >_<
You select "7" and the visual has 5 bands