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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Bullet_Train95
Frequent Visitor

100% Stacked Bar Chart - Multiple Table issues

I'm trying to create a 100% stacked bar chart using 3 columns across 2 different tables - 1 for the Y-axis, 1 for the X-axis and 1 for the Legend.

 

These 2 tables and values are indirectly linked through a common attribute(column) in a 3rd table. Think:    Table 1 - Table X - Table 2

 

One of the columns consists of lengths, which would be used for the X-Axis. For some reason I'm getting equal summed values for each of the legend value, as below. I'd like to make it look like the visual below it. 

Power BI Forum photo.pngPower BI Forum Photo 2.png

1 REPLY 1
amitchandak
Super User
Super User

@Bullet_Train95 , The year/legend. This means the y-axis column and legend should come from common tables

 

If you trying create measure across table, where one table have some data , you need make sure your measure get filtered based on another table

 

If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.