Groups for pareto

[TomSinAA]

I am using Pareto visual: Pareto by sio2Graphs.  I have a field with numbers that I want to put into groups for the pareto. My numbers range from 0 to 10000.  I want to create groups such as: 0-60, 61-75, 76-120, >120.  I would then use the groups on the pareto. How do I do that?

[v-lionel-msft · Accepted solution]

Hi @TomSinAA ,

You can create a calculated column like this.

Range = 
SWITCH(
    TRUE(),
    [Numbers] >=0 && [Numbers] <=60, "0-60",
    [Numbers] >60 && [Numbers] <=57, "61-75",
    [Numbers] >75 && [Numbers] <=120, "76-120",
    ">120"
)

Or you also can use "Add conditional column" feature in "Edit query".

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[TomSinAA]

thanks

[amitchandak]

@TomSinAA , refer if segmentation can help

https://www.daxpatterns.com/dynamic-segmentation/
https://www.daxpatterns.com/static-segmentation/
https://www.poweredsolutions.co/2020/01/11/dax-vs-power-query-static-segmentation-in-power-bi-dax-po...
https://radacad.com/grouping-and-binning-step-towards-better-data-visualization