Forum Discussion
newpbiuser01
3 years agoHelper V
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...
johncolley
3 years agoSolution Sage
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!