Group or Classification in PowerBi

Power BI
1

Dear All

Please I have been trying to group or classify a data in my powerBI

For Example: Nigeria - #5M, Seieria Lone - #2M, Ghana - #10M, Liberia - #10, Lagos - #3M.

I now want to classify: Africa = #2M - #4M, N. Africa = #5M - #8M…
So as to automatically populate the sales

How do I go about it?

2

@Dave_Adejumo,

Seems like a classic Dynamic Grouping scenario. @Greg has put together a fantastic section on this in the DAX Patterns category. Should give you everything you need:

Dynamic Grouping

  • Brian
1 Like
3

Thanks @BrianJ. I will look through it

1 Like
4

@Dave_Adejumo,

:+1:. With all the explanation, examples and videos Greg put together , you should be good to go but if you run into any trouble just give a shout.

  • Brian
1 Like
5

Agree what @Greg has done is this one thread is great and covers everything you need for this technique

6

Hi @Dave_Adejumo, a response on this post has been tagged as “Solution”. If you have a follow question or concern related to this topic, please remove the Solution tag first by clicking the three dots beside Reply and then untick the check box. Also, we’ve recently launched the Enterprise DNA Forum User Experience Survey, please feel free to answer it and give your insights on how we can further improve the Support forum. Thanks!