Forum Discussion
Creating buckets/bins based on value ranges
Hello and thank you taking a look at this.
I am looking for a way to put a range of $ values into custom bins, which I could then use in a number of combo charts with other variables. As I understand, I can use a grouping to specify my ranges. However, it seems to me these bins will not be automatically filled as new data is pulled during refreshes. Is this correct? If so, what would be the best way to perform this grouping in way where all exsisting and future new values will be categorized.
Thank you,
Yev
YevD , You need to dynamic segmentation using independent table
refer if my video can help
Dynamic Segmentation, Bucketing or Binning: https://youtu.be/CuczXPj0N-k
or blog
else
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
7 Replies
YevD , You need to dynamic segmentation using independent table
refer if my video can help
Dynamic Segmentation, Bucketing or Binning: https://youtu.be/CuczXPj0N-k
or blog
else
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Hi, YevD
I am not sure if I understood your question correctly.
Please try to create a grouping table something like below, which is separated and not connected with other tables in the model.
The values can be always segmented into the group by writing a DAX measure.
If you have a sample pbix file, please share a link here, then I can try to look into it to come up with more accurate solutions.
Hi, My name is Jihwan Kim.
If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.
Linkedin: linkedin.com/in/jihwankim1975/
Twitter: twitter.com/Jihwan_JHKIM
Hi Jihwan_Kim, would you be able to help out with the DAX measure or the claculated column?
Hi, YevD
Thank you for your feedback.
Please share your sample pbix file's link.
I still suggest having a separate grouping table, but I want to see the sample pbix file.
Thanks.
Apoligies for the lack of clarity. Let me try try again:
I have a column which lists a range of values which I would like to segment into buckets. I would then like to create use these buckets in my charts as either axis, legend, or values.
I have looked into the dynamic segmentation (there is a number of posts here), but feel like it might be an overkill at this point because once a value gets classified into the bucket it remains in it. I am thinking that a claculated column should serve the purpose, but again, I am a novice and might be missing something.
Hello Jihwan_Kim and amitchandak ,
Sorry for the delay. Here is a sample file outlining my goal. I would love to bucket the 'Amount' variable into various ranges depending on the visual. I'd be beyond grateful if you could help me with setting up the <=$100M, $100M-$500M, and $500M+ buckets. I think I should be able to create new ones using them as the template.
https://1drv.ms/u/s!AgeVqxpmuh7I9QNxnhmEfWK-YvaI?e=hx1YZ5
Cheers!
YevD
Hi, YevD
Thank you for sharing.
Sorry that I cannot know what you want to see.
Please check the link down below.
https://www.dropbox.com/s/ppkthckjple36ec/Sample_Buckets.pbix?dl=0
Hi, My name is Jihwan Kim.
If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.
Linkedin: linkedin.com/in/jihwankim1975/
Twitter: twitter.com/Jihwan_JHKIM
