Forum Discussion
column value based filter
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 .
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.
4 Replies
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.
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.thank you so much ,, I tryed your solution it's great.🙏
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.
