cancel
Showing results for
Did you mean:

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Anonymous
Not applicable

## Creating banding based on measure

Hi Experts

using live connection to cube.

I have a measure which give me Margin % values from 1% to 50%.

How could I group and or band these into the follwing bucket.

<10%

10 to 20%

21 to 40%

>40%

So I could add this a a filter over my data..

3 REPLIES 3
Community Support

Hi  @Anonymous  ,

Here are the steps you can follow：

1. Create measure.

``````Measure 2 =
SWITCH(
TRUE(),
'Table'[Measure]<=0.1,"<10%",
'Table'[Measure]>0.1&&'Table'[Measure]<=0.2,">10%&&<=20%",
'Table'[Measure]>0.2&&'Table'[Measure]<=0.4,">20%&&<40%",
'Table'[Measure]>0.4,">40%"
)``````

2. Result.

Best Regards,

Liu Yang

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

Super User

@Anonymous check this post for dynamic segmentation.

Check my latest blog post Compare Budgeted Scenarios vs. Actuals I would  Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.

Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤

Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Anonymous
Not applicable

Hi perry2k

I cannot use that method as I am connecting to a cube live connection.. I have to some how utilise the measure..and or use an alternative method

Announcements

#### Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

#### Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

#### Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

#### The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors