Forum Discussion
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.
1 Reply
- amitchandak
Super User
Anonymous , 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.
