Forum Discussion
Do5779
3 years agoHelper II
Selectedvalue - conditional formatting - slicer value
Hi Experts,
I hope this is the right place to get some help for my issue:
I would like to do something like this:
DAX Fridays! #212: VALUES vs SELECTEDVALUE to conditional format a line chart - YouTube
And for a Test I did it how it was explained and it works:
Test4 =
var selectvalue = VALUEs(Abfrage1[id])
return
If(selectedvalue(Tabelle[ID]) in selectvalue, "y" , "n")
but for the real data with the same code:
Test4 =
var selectvalue = VALUEs(Abfrage1[Index.1])
return
If(SELECTEDVALUE(Member[Index.1]) in selectvalue, "y" , "n")
I get only "y" as the results...
Does someone has a tip for me😢?
Hi Do5779
The screenshot is not clear. Would you please share a larger one?However, please make sure 'Abfrage1' table is the slicer table and 'Member' is the one used in the table visual. If the opposite is true then you need to interchange the table names in the formula.