Forum Discussion
Line Chart not plotting for all Dates
Hi,
I have the following measure that calculates an InjuryRate:
InjuryRate = Calculate(Countrows(IncidentReports);IncidentReports[Incident Classification]="XYZ")*1000000/[TotalManHour]
So, the InjuryRate values is unique for each date, as the TotalManHour value changes every day. When I put the InjuryRate measure on a Card, the value updates every time I change the date slider. So, there are no problems in calculating this measure and showing the most updated value on a card.
Now, I would like to plot the InjuryRate measure againt time on a line chart. However, the InjuryRate does not calculate for each date value. Instead, it only calculates the value for the two dates that have en entry with Incident Classification=‘XYZ’ and draws a straight line between these two points.
How can I make sure that in the line graph, the InjuryRate measure calculates for each date value?
If it helps, have the following tables:
- A 'DateTable' table with a [Date] column.
- An 'IncidentReports' table with a [Date of Incident] column. The [Date of Incident] is linked to the [Date] column of the 'DateTable'.
- A 'Manpower Summary' with a [Date] column that is used to calculate the [TotalManHour] measure. The Manpower Summary[Date] is again linked to the [Date] column of the 'DateTable'.
hi Anonymous
If so, you may try this formula instead of [TestMeasure]
New TestMeasure = CALCULATE([Long Time Injury Frequency Rate],FILTER(ALL(APier_DateTable),APier_DateTable[Date]<=MAX(APier_DateTable[Date])))Please replace ',' with ';' when your copy the formula.
Regards,
Lin
7 Replies
- AnonymousNot applicable
Hi there -
Do you mind sharing a sample file of yours for me to look at? I think it will be easier to just look at the file, work on it straight away.
Thanks
- AnonymousNot applicable
Hi,
Here's the file that I was working on: https://apiercloud.egnyte.com/dl/NgWLDS7Gzv
You can see that the cards display the correct value when the date is changed in the slider. However, the line chart only plots two values.
- v-lili6-msftCommunity Support
hi Anonymous
Since there are only two date have the data for this measure, you could use a table visual instead of line visual see the details.
and for the value in card visual, it is a measure totals problem. Very common. See this post about it
https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907
If you still have problem, please share your expected output in this sample report.
Regards,
Lin