Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Filtering / Visual Level Fitlers for Slicers

Multi Layered Question!   New to Power Bi but I want to create a report that has multiple options for filtering and to change the sales figure based off of each filter selection. These filters are ...
  • MFelix's avatar
    MFelix
    8 years ago

    HI Anonymous,

     

    Don't know if you want to use all the select values on the slicer but try something like this:

     

    Sales WITH FILTER = 
IF (
    DISTINCTCOUNT ( Sales[Country] )
        > 10 ;
    BLANK ();
    SUM ( Sales[Sales] )
)

    Replace 10 by the maximum number of selections on the slicer you want to have before blank.

     

    Regards,

    Mfelix

Anonymous's avatar
Anonymous
Not applicable
8 years ago

MFelix

 

If possible I would like to select more than one option on the slicer ... Thank you for all your help!

MFelix's avatar
MFelix
Super User
8 years ago

HI Anonymous,

 

Don't know if you want to use all the select values on the slicer but try something like this:

 

Sales WITH FILTER = 
IF (
    DISTINCTCOUNT ( Sales[Country] )
        > 10 ;
    BLANK ();
    SUM ( Sales[Sales] )
)

Replace 10 by the maximum number of selections on the slicer you want to have before blank.

 

Regards,

Mfelix