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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more

Reply
SteveK66
Frequent Visitor

Good visualization for comparison of milestone dates

Need a good way to compare key clinical trial milestone dates.  Comparison would be actual dates against plan or against forecast.  There are approximately 12 key milestone dates in a clinical trial that need comparisons

4 REPLIES 4
amitchandak
Super User
Super User

@SteveK66 , You can try Matrix Visual, not sure that is the best

 

Matrix as Project plan Visual: https://youtu.be/R25QoiyoSVs

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

Many thanks for answering. Don't think that this is going to do it as I need to compare just the milestone dates across many different scenarios - Original Plan, Latest Plan, Actual, Forecast etc.  The clinical trials span many years.

 

Anonymous
Not applicable

Are you trying to show multiple clinical trials in the visual at the same time? Also, do you want to display all of the different dates and how they relate to the actuals or are you just trying to compare 2 selected dates at a time? i.e Actual vs Forecast; Actual vs Original Plan; Original Plan vs Latest plan. Depending on exactly what you want to do and how much information needs to be visible at once would help to determine what kind of visual would work well.

Just for a single trial and how the dates have changed.  Date comparison could be up to 4 different dates - Original Plan, Current Plan, Current forecast & Actual.  Note that the current forecast could be a combination of actual dates plus forecasted future dates

Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

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

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors