Forum Discussion

Dragonfury's avatar
Dragonfury
Frequent Visitor
3 years ago
Solved

Creating Buckets Based on Measure Results

I'm new to powerBI so some assistance would be very appreciated. I couldn't find a solution in the search, so hopefully, I am not duplicating effort.   In PowerBI I'm trying to visualize customer o...
Need Help
Show and Tell
Tips and Tricks
  • Bifinity_75's avatar
    Bifinity_75
    3 years ago

    Hi Dragonfury , 

    - You need create a measure:

    Outstanding balance % per customer = DIVIDE(SUM(Table_[ Outstanding Balance ]),SUM(Table_[ Balance ]))

    - After, create a calculate column:

    Bucket = SWITCH(TRUE(),
[Outstanding balance % per customer]>0.1,">10%",
[Outstanding balance % per customer]<=0.05,"0-5%",
"5%-10%")

    - Pie Chart result: Use calculate column Bucket for your legend

     

    I hope it works for you, Best regards

     

Bifinity_75's avatar
Bifinity_75
Solution Sage
3 years ago

Hi Dragonfury , 

- You need create a measure:

Outstanding balance % per customer = DIVIDE(SUM(Table_[ Outstanding Balance ]),SUM(Table_[ Balance ]))

- After, create a calculate column:

Bucket = SWITCH(TRUE(),
[Outstanding balance % per customer]>0.1,">10%",
[Outstanding balance % per customer]<=0.05,"0-5%",
"5%-10%")

- Pie Chart result: Use calculate column Bucket for your legend

 

I hope it works for you, Best regards