Forum Discussion
Using a filter to filter two different tables
Anonymous,
Try this modified pbix of yours if this gets your desired filtering
Anonymous,
So your expected output is?
Please provide a sample data and expected output to help you better
Hi,
This is the sample data.
https://drive.google.com/file/d/189AHJX6i0K 0fO5Qx40O7CZa8ZeKdM7gD/view?usp=sharing
As you can see in the pic and in the pbix, i need two separate filters to make sure that each column is filtered down to the chosen model. Is it possible to have one filter only? So that both columns in each chart will be filtered correctly.
Thank you!
Anonymous,
Try this modified pbix of yours if this gets your desired filtering
Thanks! This worked well.
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!
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.