Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more

Reply
ISLANDMAN
New Member

Help with a measure for Stacked Bar Chart, needs to separate by multiple categories

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.

 

pic1.jpg

 

Here's the location table in the model.  The measure would be based on Opco, Region and Tier

 

pic2.jpg

 

Example of the measure i have tried so far, but not giving me the correct outcome.

 

pic3.jpg

 

Hoping somebody can point me in the right direction

1 REPLY 1
lbendlin
Super User
Super User

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...

Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.