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 work for a county in GA. We are transitioning to power BI. One of the things I am trying to do is filter by department, which the user selects, and have the chart show the breakout of the differing costs of the projects the department has undertaken over the last year. The data is for the previous year and is therefore static. However when I attempt to do this, I get the entire budget for the department but it is not broken up by projects. I am working on the web version of Power BI and I would understand if that were the problem.
Solved! Go to Solution.
Hi, @EricSwart ;
First of all,
I suggest you download a Power BI desktop,
and then create a measure or column by DAX.
ALLEXCEPT statement or [group] = Max ([group]) statement;
And then publish to the service;
If you still have questions, you can upload a simple table to remove sensitive data and the results you want to output.
Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, @EricSwart ;;
Hi, @EricSwart ;;
Hi, @EricSwart ;
First of all,
I suggest you download a Power BI desktop,
and then create a measure or column by DAX.
ALLEXCEPT statement or [group] = Max ([group]) statement;
And then publish to the service;
If you still have questions, you can upload a simple table to remove sensitive data and the results you want to output.
Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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.