How to create sub group from group ?

[Anonymous]

Hi All

My objective is the highlight type of supplier using Grouping feature in PBI :-

below 3 company in red box i like to group them as robotics supplier.

So that for my report i can highlight row color by supplier .

Hope some one can advise me how to achieve this ?

https://www.dropbox.com/s/d3gw7oztqorlwux/PBT_V2021_111%20group%20by%20supplier%20FA%20and%20Robotic...

My PBI file :-

Paul

[amitchandak · Accepted solution]

@Anonymous , I the first screenshot all companies contains ROBOT, in Second one not.

What is the logic.

You can try binning or static 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...

Color can also be based on only ROBOT using color measure, if that is way to find.

[Anonymous]

Hi Amit

You know many good link

Paul