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

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
Icon for Super User rankSuper 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