Forum Discussion
Showing visual only when slicer selected
Hi Anonymous ,
I tried the following measure for transparency at my end without SWITCH statement and it works for me:
Make Transparent =IF(ISFILTERED(ClothingSales[Category]),"#FFFFFF00","#FFFFFF")Try this and see if it works.Also, in your measure, you are missing "#" from 2nd condition. You are just using "FFFFFF". It should be "#FFFFFF'.Thanks,PragatiHi Anonymous ,
I wrote a blog sometime back on similar functionality. Can you check once if you are following all these similar steps:
If still it doesn't work, then share your pbix file by removing any sensitive information from it.
Also I am wondering; if this was not working then why was the solution accepted. 🙂
Thanks,
Pragati
Hi Pragati11 ,
Sorry for misunderstnding. Here is the sample data Snippet,
Slicer > Customer Name; which is a column in my Table
Count > Matrix Visual; which is a measure
If I create,
Filter Selected =
IF (
CALCULATE (
HASONEVALUE ( Client[Customer_Name] ),
ALLSELECTED ( Client )
)
= TRUE (),
1,
2
)
If I try to apply the "Filter Selected" measure on my Matrix Visual, but i can't apply on it.
I can not dropdown and Select "1". You could do it in your example, maybe because your columns are directly coming from your data, they may not be measures. Hope you have understood the problem. If not, let me know I will explain again but want to solve it anyow.
HI Anonymous ,
I mentioned in my previous response that I am using a measure on my matrix and I am able to apply visual level filter.
Are you saying against Filter Selected measure, you are not able to chnage selection using dropdown as shown below:
You need to select is option from dropdown. --> Then write "1" in the next box --> Then APPLY
If this doesn't work, try following:
Filter Selected measure is based on your CUSTOMER NAME column.
I suggest moving CUSTOMER NAME and COUNT measure to your matrix visual.
Then try applying Filter Selected as a visual level filter to your matrix. This should work.