Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
btfergie
Helper I
Helper I

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

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.

 

btfergie_0-1663346502954.png

btfergie_1-1663347331269.png

 

 

4 REPLIES 4
tamerj1
Super User
Super User

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

Thank you but it does seem to be date type.

btfergie_0-1663605119125.png

 

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

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.