Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code FABINSIDER for a $400 discount.
Register nowGet inspired! Check out the entries from the Power BI DataViz World Championships preliminary rounds and give kudos to your favorites. View the vizzies.
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.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code FABINSIDER for a $400 discount!
Check out the February 2025 Power BI update to learn about new features.
User | Count |
---|---|
126 | |
113 | |
72 | |
65 | |
46 |