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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
btfergie
Helper I
Helper I

Creating a visual based on measure returning a date

I am having trouble creating a line chart based on the filtered table below.  It shows the Status (Stage) in production,  how long it takes to get to that stage (Running Total), and a lookup to a calendar day for the completion of the stage.  The Calendar table has an index of working days.

 

I use the measure below  to calculate the end date of different stages.

 

ProjectedStatusDate = calculate(LOOKUPVALUE('Calendar (EDWn)'[Calendar Date],'Calendar (EDWn)'[WorkDayIndex],[Start WorkDayIndex]+[RunningTotalMeas]))

 

I can put this in a table visualization...

btfergie_0-1661812569314.png

 

However I can't seem to get any sort of visualization to work that shows Status Num vs Projected Status Date.  Power BI won't let me drop the Project Status Date measure in the X or Y axis fields.

 

Thanks!

 

 

2 REPLIES 2
btfergie
Helper I
Helper I

Thank you @amitchandak , I am still confused on how this will allow me to make relationships with the new date column.

amitchandak
Super User
Super User

@btfergie , I have used the whole number here, you need a calendar and your date measure

Dynamic segmentation -Measure to Dimension conversion: https://youtu.be/gzY40NWJpWQ

 

Another example

Customer Retention with Dynamic Segmentation, New/Lost/Retain Customer Count: https://www.youtube.com/watch?v=W4EF1f_k6iY

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

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