Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Remove elements from View that is selected in the Slicer

Hello,        In my report page, I have couple of views that shows relation between Countries and other values and different Slicers including one for the Country. The country slicer updates al lvi...
Need Help
  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    5 years ago

    Hi, Anonymous ;

    In my case , we could change the measure as follows:

    Inverse Selector = 
IF(NOT(ISFILTERED(Slicer[Country])),1,IF(MAX([Country])  IN DISTINCT('Slicer'[Country]),0,1))

    The final output is shown below:

    In your case, you could try :

    Inverse Selector =
VAR __CurrentCountry =
    MAX ( Merged_VOL_OMD[OMD.MAIN COUNTRY(ENG/BILLING/VENDORS/FINANCIALS)] )
VAR __Countries =
    DISTINCT ( RemoveCountries[Country] )
RETURN
    IF (
        NOT ( ISFILTERED ( Slicer[Country] ) ),1,
        IF ( __CurrentCountry IN __Countries, BLANK (), 1 ))

    Best Regards,
    Community Support Team_ Yalan Wu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-yalanwu-msft's avatar
v-yalanwu-msft
Icon for Community Support rankCommunity Support
5 years ago

Hi, Anonymous ;

According to your screenshots and your measure ,I find one of the columns is inconsistent.

so  you could modify the measure as follows:

Inverse Selector =
VAR __CurrentCountry =
    MAX ( Merged_VOL_OMD[OMD.MAIN COUNTRY(ENG/BILLING/VENDORS/FINANCIALS)] ) 
VAR __Countries =
    DISTINCT ( RemoveCountries[Country] ) 
RETURN
    IF ( __CurrentCountry IN __Countries, BLANK (), 1 )

Attached is a simple example created by myself for your reference.
Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Thanks v-yalanwu-msft , that was a good catch. Thanks for the solution demo file. 

     

    I want is,

    * If nothing is selected in the slicer, all the data should be shown. - So, if no country is selected, all 3 countries should appear.

    * Else, not to show the selected items in the slicer. - If "Spain" is selected in the Slicer, "Spain" should not be shown, the other 2 must be shown.

     

    Our solution right now takes care of the "Else" part, how can we manage the "If" part.