Forum Discussion

bananakingchiu's avatar
bananakingchiu
Regular Visitor
8 years ago
Solved

Slicer grouping

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.

 

8 Replies

      • bananakingchiu's avatar
        bananakingchiu
        Regular Visitor
        8 years ago

        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

  • NhiLe297's avatar
    NhiLe297
    Frequent Visitor
    5 years ago

    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!