Forum Discussion
Bar Graph Troubles, incorrect values
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?
Anyone?
Did you solve this problem? Cause I have a similar problem counting the amount of dates that has occured in a month where the graphs do not show the correct amount..
Hi,
i did not solve this problem and moved on to another solution (and a different tool).
One really ugly way I used for a short while was to create two graphs with the same date range and positioned them over eachother with transparant background using line graphs. It worked suprisingly well but was not a good solution.
At the moment I am thinking about implementing a seperate databse and mining the data from our issue handling system (Jira from Atlassian) to be able to display the trends the way I need.
Kind regards, Johan