Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 ?
Solved! Go to Solution.
I found the solution.
The solution was to use directly the DEFECT table since it's a dimension's table.
So, in the shared's axis of my bar chart I simply deleted the old defect_code values (since it was from the wrong table) and I added the defect_code from my dimension's table.
I found the solution.
The solution was to use directly the DEFECT table since it's a dimension's table.
So, in the shared's axis of my bar chart I simply deleted the old defect_code values (since it was from the wrong table) and I added the defect_code from my dimension's table.
@Anonymous . hope code type was there in the list "add drill through parameter"?
I didn't setup the drill through. Power BI automaticaly added me the option.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
99 | |
76 | |
64 | |
58 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |