Forum Discussion
Anonymous
6 years agoNot applicable
Using a filter to filter two different tables
I have a table which forecasts the units of each model that will be sold and a separate table which forecasts the volume of each model that will be sold. I also have a table which is much more comple...
- 6 years ago
Anonymous,
Try this modified pbix of yours if this gets your desired filtering
mussaenda
6 years agoCommunity Champion
Anonymous,
Try this modified pbix of yours if this gets your desired filtering
Anonymous
6 years agoNot applicable
Hi mussaenda ,
This worked well when we wanted to filter the actuals and budget diagram(in terms of units). But we've noticed that the filter isnt working on the budget portion of the other diagram(revenue actuals and budget). Is it possible for the filter to work for both diagrams and both columns for these diagrams?
Thank you!
- mussaenda6 years agoCommunity Champion
Anonymous,
Yes.
Create a relationship on the tables.
I just created relationships on the tables you required before that's why it is not reflecting on the revenue table.
- Anonymous6 years agoNot applicable