Forum Discussion
Table filtered by slicer
Thank you. I get it. Actually my problem is bit more complex than this - the states and LGs are not a one to many realatioship. The LG is a kind of local geography that are poorly aligned with the states boundaries, that is, one LG may possibly cross 2 to 3 states. The problem I'm faced with is to apply the concordance data (i.e. proportions of a LG assigned to different containing states if it's not fully contained by one signle state) to LGs once a state is selected. I'll repost my problem as a new post. For this consider case closed. Thank you.
Charlie
You cannot create a new table using the value selected on slicer.
On this case if you place the slicer and on other visual place the LG names they will be filtered directly no need to create a new table.
Take attention that this is assuming a one to many relationship with single side filtering and you must use the one side tabke as your slicer.
Regards,
MFelix
Thank you. I get it. Actually my problem is bit more complex than this - the states and LGs are not a one to many realatioship. The LG is a kind of local geography that are poorly aligned with the states boundaries, that is, one LG may possibly cross 2 to 3 states. The problem I'm faced with is to apply the concordance data (i.e. proportions of a LG assigned to different containing states if it's not fully contained by one signle state) to LGs once a state is selected. I'll repost my problem as a new post. For this consider case closed. Thank you.
Charlie
