Forum Discussion
Filtering from a diferent visual
Hello Everyone,
i have built a report but cant manage to figure how to do one last thins, having a "secondary" visual also filter the all visuals
in this report everything works when i click the Horizontal Bars, but if i would like to see what belongs on the "aged" or " Quality code" buckets when clicking on them it wont filter the other, how can i make this happen?
inittial thought was to create a refferance table since the aged and on hand are feeding from the same table
thanks in advance
5 Replies
It looks like you want to be able to filter your dimension tables from selecting from the fact table, which you can do using bidirectional relationships. Be aware this can affect report performance:
THe columns from the Horizontal Bars are from which table? And which table will be filtered, wenn you click on it.
It do not see which table is used in the different visuals.
From the Inventory Focus, i was planning and tried making a referance table just pulling the "aged" and some sonstants such as "Variety" but it wouldnt work
tried making a bi directional but no luck at all
