Slicer grouping

[bananakingchiu]

Hello everyone, i am a new user of power BI. Just find out some problem cannot solve.

I would like to group some number with the same number in different group for filter in Slicer.

Here is the example.

1,2,3,4,5,6,7,8,9,10

Group A : 1,2,3,4,5,6,7,8,9,10

Group B : 5,6,7,8,9,10

Group A is all number and Group B is only greater than or equal to 5.

Does any method can solve my problem?

Thank you so much.

[NhiLe297]

Hi @parry2k 

I need urgent help as well. For slicer.

For example, the above Grade example, what if there is a 3rd Grouping beside 0-100 and 50-100 but this one won't expand into further check-boxes, how do I create this 3rd box? Thank you!

[bananakingchiu]

Dear Team , i need your urgnet help.

Thank you so much!!!

[parry2k]

@bananakingchiuwhat is the objective of grouping these numbers?

[bananakingchiu]

@parry2k

i am calculating some score.
i want to use a slicer to filter out people who are greater than 50 marks.

And i want to see the overall performance.

So there two group i need.

One is all score, second is greater than 50 marks.

So 0-100 mark

Group A: 0-100 mark

Group B: >=50 marks(50-100)

Thank you so much

[parry2k]

ok, so you have sample data you can share to get this going.

[bananakingchiu]

@parry2k

I want the Slicer only have two options.

1) All score (0-100)

2)Higher than 50% (50-100)

because there some nuumber overlap two of group, so i don't have any idea to do it.

Thank you

[parry2k · Accepted solution]

sample attached to give you an idea.

[bananakingchiu]

@parry2k

Thank you so much for your help.