column value based filter

[Lily_DS]

hello 

I am building a dashboard contains a filter of companies name
i need please hide the other names depends on this filter
for example:

table look like:

name	amount
aramco	200195$
sabic	412000$
nobco	211300$
tsnee	350100$

if filter = "nobco"

table will be : ( hide any other companies name)

name	amount
-	200195$
-	412000$
nobco	211300$
-	350100$

i try to use ISFILTERD () functio but it ask for one value, I don't know if there is a way to use it with IF and conditions .

[v-zhangti · Accepted solution]

Hi, @Lily_DS 

You can try the following methods.
Measure:

Name measure = 
SWITCH(TRUE(),
    SELECTEDVALUE ( Slicer[name] ) = BLANK (),SELECTEDVALUE ( 'Table'[name] ),
    SELECTEDVALUE ( Slicer[name] ) = SELECTEDVALUE ( 'Table'[name] ),SELECTEDVALUE ( 'Table'[name] ),
    "-"
    )

Is this the result you expect?

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Lily_DS]

thank you so much ,,  I tryed your solution it's great.🙏

[vojtechsima]

@v-zhangti ,
Hello,
I am not the author of this thread, however, I am interested in this topic, I checked your solution, and it's great.
You create a new table just for the slicer, I wonder if you can do it within the same table or have a relationship between those two tables.

[mangaus1111]

Hi @Lily_DS ,

see my pbi file

https://1drv.ms/u/s!Aj45jbu0mDVJizIXmIgvc_G-Fc_i?e=qrj22n

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.