Forum Discussion
Drill through adding additional filters
Hi all,
I am creating a page which shows the following :
| Employee Name | Department | No of High Rated Errors | No of Low Rated Errors |
| John Smith | HR | 4 | 2 |
| Michael Jackson | Sales | 3 | 1 |
The "No of High Rated Errors" and "No of Low Rated Errors" are both CALCULATE(COUNT( measures.
From this I have created a Drill Down Page which shows me the same table as above, but also another table as below :
| Error Type | Flag High Error | Flag Low Error |
| Error Type 1 | Yes | |
| Error Type 2 | Yes |
I am trying to create the drill down to show that when I select a individual on the first page, drill down by that employee name only to the drilldown page, allowing me to see the "Error Type" and if either "Flag High Error" or "Flag Low Error" is applicable.
Unfortunately at the moment, the drilldown also applies other filters on the drilldown page such as the "No. of High Rated Errors" = 4, which removes the other "Error Types" when drilling through.
Is it possible to have the drilldown to only have the "Employee Name" Filter when drilling down from the first table?
Anonymous , Hope you are talking of drill through
In the drill through you have an option to add drill through the field here. You can remove the filter which you do not want to pass
https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-drillthrough
2 Replies
Anonymous , Hope you are talking of drill through
In the drill through you have an option to add drill through the field here. You can remove the filter which you do not want to pass
https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-drillthrough