Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more
Good afternoon everyone.
I need help with a stacked bar chart, where one value is the number of location incidents, while the other is an actual count of locations based on Region. The filters separate Company codes by "FXE' and "FXG" , Region and Tier.
In this example, i have the chart showing Regions on the X axis, the count of Incidents for each region, but the total locations is not showing correct. Its actually showing the actual count of all locations based, regardless of the filters.
For instance, the bar chart for Western is showing the correct incidents, and the total locations is 19, but i have a measure that subtracts the incidents from count of locations, so its showing 16 (19 all up locations across all regions - actual region incidents). what it should show is Actual incidents 3 and Locations 3. (this will show 100% later)
Example of issue.
Here's the location table in the model. The measure would be based on Opco, Region and Tier
Example of the measure i have tried so far, but not giving me the correct outcome.
Hoping somebody can point me in the right direction
Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot). Leave out anything not related to the issue.
If you are unsure how to do that please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Please show the expected outcome based on the sample data you provided.
If you want to get answers faster please refer to https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 9 | |
| 5 | |
| 4 | |
| 3 | |
| 3 |
| User | Count |
|---|---|
| 24 | |
| 12 | |
| 11 | |
| 9 | |
| 8 |