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

MFelix's avatar
MFelix
Super User
8 years ago

Hi Anonymous,

 

Do you want to let the user select more than one country on your slicer or only one?

 

If it's only one you should replace the second part by 1 and drop the formula.

 

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