Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
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?
Solved! Go to Solution.
@indyb , 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
@indyb , 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
Thanks for the link - it showed what i was looking for.
Essentially i needed the "Keep All Filters" toggle set to "off" which sorted my issue!
Thank you!
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
81 | |
75 | |
60 | |
37 | |
33 |
User | Count |
---|---|
102 | |
56 | |
52 | |
46 | |
40 |