Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Vote for your favorite vizzies from the Power BI Dataviz World Championship submissions. Vote now!
I've created a mockup report that mimics my real data. I give this report to all Project Managers to view their workers Available monthly hours, project forecast hours, and the variance of the two. I want to be able to use a dax formul or the filters to show only the variance >= 80 at the total level which still keeping the data drill-downs.
Right now when I filter variance greater than or equal to 80, it only filters at the project level. I noticed when I take out 'Project' from the rows then the filter will work showing only those with variance >=80. However, the Project Managers would like to see the drill down on the same page rather than drilling through to other pages and I cannot seem to figure that out.
Any help is appreciated! Here's a quick screenshot of my mockup data.
Any ideas?
I've tried IF statements in a DAX measure, but either it doesn't work or it ends up working the same as the filter which is only filtering on the project level. As mentioned, I'd like to keep the drill-downs, but have the filter work only at the top level total.
Vote for your favorite vizzies from the Power BI World Championship submissions!
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
Check out the January 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 55 | |
| 52 | |
| 41 | |
| 16 | |
| 16 |
| User | Count |
|---|---|
| 107 | |
| 104 | |
| 40 | |
| 33 | |
| 25 |