Forum Discussion
Chart not filtering based on a non connected table value
Hi All, I have 3 visuals in my report and one gets filtered based on the Year filter that i have from a unrelated table. But the other two visuals dont get filtered based on this year filter....
Anonymous
You can use in values() for unrelated tables with selectedvalue(), e.g.
Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
amitchandak Thanks Amit.
But i think i need a selector kind of measure to apply it on the visual
For example, if(selectedvalue( year[year])=query1[year],1,0)
but not sure if this is the right way to write
Hi all,
any thoughts about it please... please...
Anonymous
You can use in values() for unrelated tables with selectedvalue(), e.g.
Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.