I have this bar chart :
When I right-click in the "ret200" bar chart, I have this menu :
So it gives me the option to drill through an other page "Détails défauts" that contains a table with the details of the "ret200" values (article, code, description, quantity, etc.).
The table is supposed to show me only the value for the selected bar chart which is in my case "ret200".
But here is the problem, the table contains values that aren't "ret200".
Here is a simplified example :
In this case, when I do the drill through, it shows me "ret200" which is correct but it also shows me "ret100" which is not correct.
I found where the problem is, but I can't find a way to solve it.
In the Drill through's filter, it creates me a few filters. One of them contains the value of the bar chart that I right clicked on it.
"Defect_text" is automacialy filled with "ret200 - defect" which is the text of the item "ret200" (the one selected) and then you say to yourself that the drill through worked well? I thought so...
But the filter is refered to the wrong table in my model.
As you can see :
I have two columns (foreign key) that are named "defect_text", one is in "Inventory" and the other one is in "Quantity".
And my drill through automaticaly add a filter on Inventory's defect_text but the table's values are based on the Quantity's defect_text, so yes the drill through works well but on the wrong table.
So I have a few question.
1. Is it a relational problem ?
2. Can I say to Power BI "use Quantity's defect_text for the drill through", or change the table ?
3. Is this problem solvable ?
