Forum Discussion
Splitting Bar Chart by Color
Hello,
I am trying to create a bar chart and split the bars into different colors by the ID#. The X axis has the date, and for the y axis I used - countrows('SupplierTable'). To split the bars by ID - I put the ID in the Legend field. However, when I enable the data labels, Power BI assigns the total (e.g. 11) to all 4 "sections" - and the total becomes 44 instead of 11. What am I doing wrong? The only difference between the two graphs below is that I added the ID field as a Legend so I'm not sure why the total goes up! I'd really appreciate any help!
1 Reply
Hi newpbiuser01 , Looks like you don't have a relationship between the ID, Supplier count, or Date. You see the same value repeating like this when there's a missing relationship.
https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-create-and-manage-relationships
If you require more assistance please post more information about how your data is structured or a sample pbix.
If this answer solves your problem please mark it as a solution!
