Replicating the same chart in Power Bi

[Learner53]

Hi there,

I am working on a project and have 500 companies. In excel I can do the below, how would I be able to replicate this in Power Bi?
I have already sorted 1-500 using RANKX

 

[Matt Allington]

You need to create the groups as a single calculate column. Ideally you have a company table already. You can then use banding on the rank. I have an article here that should help. Banding in DAX - Excelerator BI
you could also use a switch(true() Statement to do the banding in the column