How do i Hide one item in slicer depending on selection from other slicer

[Anonymous]

i am Using below DAX

Curreny Selected =

IF(CALCULATE(COUNTROWS ( FILTERS ( Company[Country]) ),

ALLSELECTED (Company[Country])) >1 ,"Group", IF(HASONEVALUE(Company[Country]) && SELECTEDVALUE('Currency'[Currency],"Please Select Currency AS Needed")="Local","Local","Group")

)

I want Result as following

When i select Multiple countries from country slicer i should get only one selection in Currency

slicer i.e.

it should only show Group for multiple selections

if there i single selection then it should show both group local .

[v-piga-msft]

Hi @Anonymous ,

For your requirement, more details will be helpful.

If it is convenient, could you share your data sample which could reproduce your scenario so that we could help further on it.

Best Regards,

Cherry

[Anonymous]

I can't share the exact data but i can create a resemblance in excel and share that will it be okay

[v-piga-msft]

Hi @Anonymous ,

You could share your excel file to OneDrive and post the link here. Do mask sensitive data before uploading.

Best  Regards,

Cherry