Filtering using a table

[abhi87]

Hi,

So, I have a table called Work Zone Related, I want to use this table and filter out rest of the dashboard. So, if work zone realted is yes for one of the crashes, I want it to show up on the viusals, and don't want other stuff to show up.

Thanks in advance

[amitchandak]

@abhi87 ,based on what I got so far

can make measure as blank and background and font color as #FFFFFF00 for such scenario and this will give feel visual is hidden 

color measure = if(isfiltered(Table[Workzone], "#FF0000","#FFFFFF00" )

Use such a measure in conditional formatting using field value option

[abhi87]

Hi @amitchandak 

I believe you understood my explaination wrongly. In my final report the work zone visual won't be there. I have kept it right now for the screenshot.

So, excluding that visual I have four other visuals. Right now these four visuals are taking into account all the data. What I want them to do is only take the work zone table data into account, and only show the ones with "yes" in the visual.