Group all slicer's unselected value as one ?

[Lvadagnini]

Hello everyone !

First of all thanks a lot for this well active forum, it has helped me a lot to learn and deal with PowerBI 🙂

Here is my question : I have a slicer made of market players and some clustered column charts on my dashboard. Sometimes I want to compare the influence of one (or many) specific players on the full market. I can use the "select all" option on my slicer but as I have 30+ players the charts are difficult to read. I would like to know if it is possible to create a group within the slicer called "Others" and made of the unselected players ? If yes so do you have some tips ?

Thanks in advance !

Lucas

[v-eachen-msft · Accepted solution]

Hi @Lvadagnini ,

Here is my sample data. You can get the results you want according to my ideas.

Then create two measures.

Selected =
CALCULATE (
    SUM ( Slicer[Value] ),
    ALLSELECTED ( Slicer[Slicer] ),
    VALUES ( Slicer[Slicer] )
)

Other =
CALCULATE ( SUM ( Slicer[Value] ), ALL ( Slicer ) ) - [Selected]

Here is the visual.

Best Regards,

Eads

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[v-eachen-msft · Accepted solution]

Hi @Lvadagnini ,

Here is my sample data. You can get the results you want according to my ideas.

Then create two measures.

Selected =
CALCULATE (
    SUM ( Slicer[Value] ),
    ALLSELECTED ( Slicer[Slicer] ),
    VALUES ( Slicer[Slicer] )
)

Other =
CALCULATE ( SUM ( Slicer[Value] ), ALL ( Slicer ) ) - [Selected]

Here is the visual.

Best Regards,

Eads

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Lvadagnini · Accepted solution]

Hello Eads,

Sorry for the late reply ... No excuses ! Anyway it works perfectly : thanks a lot for your time and your help 🙂

Have a good day !

Best regards,

Lucas