Forum Discussion
Bar Graph Troubles, incorrect values
You need to make relationships between the calendar table and your date field(s)
Yeah, I figured that too...but it did not solve my problem. Now both the CreateDate and the MovedDate shows the same count even if the raw data shows that MovedDate count should be 15 and the CreateDate count should be 5.
I can't have two active relationships, but I have one active and one inactive relationship between these two tables now. The bar graph displays the values for CreatedDate and MovedDate as the same value, altogh different for each day...
//Johan
I'm not sure what you're shoving into your graph but try making a measure to count instances, using the relationship in question for whichever is currently inactive. It sounds like it's using the active relationship for both counts.
When I change the active relationship i get different graphs so I think you are on to something. How can I get it to not use the active relationship for both counts?
I tried adding measurements but it does not seems to make a different...or I did it in the wrong table...or something...
As seen in this screenshot, when I plot the values in different graphs, then look fine. But when I combine them, Power Bi seems to be using the active raltionship to display the data incorrectly. The left-most column shows 12 Moved in the middle graph and 9 Created in the third graph but in the first combined graph only 6 moved issues are shown.
Any idea how this can be prevented?