Forum Discussion
Automatic grouping data by range
I have manually grouped the data as seen in the below screenshots.
Is there a way to automatically group this data so I do not have to go back and edit every time new data is added into my dataset?
i.e every time data is added in the range of 250K-680K it will be automatically grouped under the range 250K-680K. Please see below screenshots.
Nathaniel_C - you were a brilliant help in my previous post re data ordering- i would be greatly appreciative if you have any insight to this issue i am facing
Hi,
Create a table like this and name it Buckets
Lower Upper Bracket 0 30,000 0 - 30K 30,000 2,50,000 30 - 250K 2,50,000 6,80,000 250 - 680K 6,80,000 10,00,000 680K - 1M 10,00,000 10,00,00,000 > 1M Write this calculated column formula
Column = CALCULATE(MAX(Buckets[Bracket]),FILTER(Buckets,Buckets[Lower]<='Table'[original contract value]&&Buckets[Upper]>='Table'[original contract value]))Hope this helps.
14 Replies
Hi,
Share the download link of your PBI file and clearly show the grouping that you want to create.
Hi,
Anonymise your data and share the download link of that file.