Forum Discussion
Filter by another field
Dear community,
How can I filter a given field by the selected value of another field?
I have a kind of hierarch that tells me what I produced of a given stock (let’s call the fields “component” and “product”). It is a many to many relation (many component produced to many products), and there can be more than 10 steps.
What I would need is a “button” that takes the selected value of the stock ID of the components selected on the visual, and adds it somehow to a filter, that filters the product (changing the given filter criteria), so I can drill down in this hierarch (and an other button in the opposite direction).
Thanks Dlmsbi
We found an alternative sollution. Thank you all for help.
6 Replies
How can I filter a given field by the selected value of another field?By linking the fields' tables in the data model in a way that the other field's table influences the table of your field.
The fields are in the same table.
Then it will filter automatically unless you have disabled visual interaction.
What I actually need is a special slicer, that saves the selected values of one column to a parameter table, and then resets filters, and filters the other column by the parameter table.
If this is important to you please consider voting for an existing idea or raising a new one at https://ideas.powerbi.com
We found an alternative sollution. Thank you all for help.
