DAX to substitute text in a slicer when filtered by another Slicer

[Anonymous]

Hi,

I have 2 slicers in my dashboard coming from the same table. What I am trying to do is when I select the value on one slicer I want it to substitute text from the values in the other slicer in addition to filtering it. For example,

Slicer 1                                 Slicer 2

When I click on Franchise in Slicer 1 I want to replace the Franchise text in  Slicer2 with Blank

I tried to create a DAX query  but it's not working. Can any one please help?

Account List =

VAR _slicervalue = SELECTEDVALUE(SlicerValue[TierType])   

RETURN

IF(_slicervalue = "Franchise", SUBSTITUTE(VALUES(FIFA_LM_Products[ProductLevel-Product]),"-Franchise","")

)

[Greg_Deckler]

I can't think of a single way to do that. Other than maybe having a table of just your options in slicer 1 and then that related to a table that has your goal slicer 2 values. But tough to tell if that would meet your needs.

[parry2k]

@Anonymous you cannot replace the text in slicer 2 but you can filter the slicer 2 based on slicer 1. In this video whatever value is selected in slicer 1, it remove values from slicer 2 that contains selected slicer 1 value, and if nothing is selected in slicer 1 it shows all the values in slicer 2.

See if this logic can get you what you are looking for, left side is slice 1 and right hand side is slicer 2. 

Would appreciate Kudos 🙂 if my solution helped.