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 t...
bananakingchiu's avatar
bananakingchiu
Regular Visitor
8 years ago

Dear Team , i need your urgnet help.

Thank you so much!!!

parry2k's avatar
parry2k
Super User
8 years ago

bananakingchiuwhat is the objective of grouping these numbers?

  • 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

    • parry2k's avatar
      parry2k
      Super User
      8 years ago

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

      • bananakingchiu's avatar
        bananakingchiu
        Regular Visitor
        8 years ago

        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