Forum Discussion
Line Chart not plotting for all Dates
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
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
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.
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
Hi Anonymous
Thank you for the response, but I believe this does not really answer my question.
In the table view above, I would like the measure to be calculated for all dates on each row.
So, I would actually like to plot the date against the value that appears in the 'Total' row in the table above.
Based on your responde I tried the below and could get the desired line chart by plotting date against the below measure:
TestMeasure = TOTALYTD([Long Time Injury Frequency Rate];APier_DateTable[Date])Which now correctly gives me the below desired line chart:However, I realise this is only working because all my data is within the 2019 year. This function will no longer work once we start gathering data on 2020.
Is there an alternative way for me to produce the above line chart?