topic Re: Can't seem to create a line chart with date measure field in DAX Commands and Tips

Can't seem to create a line chart with date measure field

btfergie — Fri, 16 Sep 2022 16:56:22 GMT

I am trying to create a line chart visual with status date on the X axis and status number on the Y axiz but can't use the measure index or date fields in the X axis.

This is related to a process going through different stages with an estimated duration known for each stage.

First I select the process type I am interested in. This gives me the duration at each stage.
Then I convert the start date to a workday index with a LOOKUPVALUE on a date table so I can count only workdays.

Start WorkDayIndex Col = CALCULATE(lookupvalue('Calendar2 (EDWn)'[WorkDayIndex],'Calendar2 (EDWn)'[Calendar Date],FIRSTDATE(MoldQual_RCGL[ProcessStart])))

Adding the Start WorkDay Index to the Completed Total duration, I get a Status WorkDayIndex measure.

Status WorkDayIndex = [Start WorkDayIndex]+sum('Mold Qual Duration Categories'[Completed Total])

I then use the Status WorkDayIndex measure to Lookup a Date.

ProjectedStatusDate = calculate(LOOKUPVALUE('Calendar2 (EDWn)'[Calendar Date],'Calendar2 (EDWn)'[WorkDayIndex],[Status WorkDayIndex]))

This all works in a table but I can seem to use the ProjectedStatusDate in a line chart visual. I can't drop the field in the field box.

Re: Can't seem to create a line chart with date measure field

tamerj1 — Fri, 16 Sep 2022 17:48:04 GMT

btfergie
Please conver the [ProjectStatusDate] to date data type using power query.

Re: Can't seem to create a line chart with date measure field

btfergie — Mon, 19 Sep 2022 16:32:22 GMT

Thank you but it does seem to be date type.

Re: Can't seem to create a line chart with date measure field

tamerj1 — Mon, 19 Sep 2022 16:50:33 GMT

btfergie

Re: Can't seem to create a line chart with date measure field

btfergie — Mon, 19 Sep 2022 18:04:44 GMT

I don't beleive it is text date type. But if it was would you suggest usaing the format function?