Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

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

Capture.PNG

 

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.
 
Capture1.PNG
it should only show Group for multiple selections
 
if there i single selection then it should show both group local .
 
3 REPLIES 3
v-piga-msft
Resident Rockstar
Resident Rockstar

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

 

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
Not applicable

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

Hi @Anonymous ,

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

Best  Regards,

Cherry

 

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.