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.

asitm's avatar
asitm
Icon for Helper III rankHelper III
5 years ago

Hi Anonymous 

unless the visual you need is a complex one, you can simply use a custom visual. will save a lot of effort putting down complex formulas (though that's part of the fun sometimes)

 

I dont know the exact visual you are looking for (your screenshot suggests column chart though), but see if this custom visual is directionally how you need this, and I can help get you the right visual. when you click on any of the legend items, that will not show on visual. for e.g. clicking on 'Backing score' legend, will hide the 'Backing score' marks, and only show the 'Client Score' marks.

https://community.powerbi.com/t5/Data-Stories-Gallery/inverse-filter/m-p/1993630#M5621


Our company has developed a tool - PBIVizEdit - to create custom visual easily. no coding required. takes 15 minutes maybe. this visual was created with that tool. link:

https://pbivizedit.com/gallery/dual_axis_scatter

 

if this interests you, you can try it yourself. if you need any additional help, let me know.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Thanks asitm , this is really cool, but it's not what I am looking for.

I am using bar charts showing Volumes (or different datas) of different countries. My requirement is, on selecting a country from the slicer, that country data should not appear in the chart. When no country is selected, all countries data should be shown. 

Check the visuals shown in previous posts.

 

  • asitm's avatar
    asitm
    Icon for Helper III rankHelper III
    5 years ago

    Hi Anonymous 

     

    I had read the previous posts. Put this out in case there was an option to use legend based filtering instead of slicer.

    But this is interesting. We haven't got to slicers yet. But when we do, we will see if the results can be implemented in slicers as well.