Alright, it's been a month now and I am exausted in looking for a solution online. I believe I have tried all the known solutions. Let me describe the problem below
I have a simple table
If I do matrix on this table, I got following results (and they are right):
However, if I try to place those values on line chart, numbers messed up
This is my settings for line chart
What magic needs to be done so that numbers are displayed correctly on line chart as in martix? Please advise whoever faced the same problem in PowerBi. Thanks!
The question you have is related with the row context of your data. When you place one of the date columns on your chart as axis, this set the context of the chart so the count of the dates is not made by the value of each date but by the one that you place on the axis.
What I mean with this is that since you are using the Createdate as your axis, if you have 7 records with CrreatedDate for january 1st all of the others columns are also 7 records you will never get the count of january 2nd because your context is the createdate.
On the matrix / table since you are using the other date columns for context you have the correct results.
You need to do the following:
Create = CALCULATE ( COUNT ( Table1[CreatedDate] ); USERELATIONSHIP ( Table1[CreatedDate]; 'Calendar'[Date] ) ) Activated = CALCULATE ( COUNT ( Table1[ActivatedDate] ); USERELATIONSHIP ( Table1[ActivatedDate]; 'Calendar'[Date] ) ) Closed = CALCULATE ( COUNT ( Table1[ClosedDate] ); USERELATIONSHIP ( Table1[ClosedDate]; 'Calendar'[Date] ) ) Resolved = CALCULATE ( COUNT ( Table1[ResolvedDate] ); USERELATIONSHIP ( Table1[ResolvedDate]; 'Calendar'[Date] ) )
If you need sample of PBIX file please tell.