Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello community, Power BI novice here, hoping to get some help creating a timeline style visual. I am trying to create a visualization that illustrates date shift on major milestones from a construction schedule. I've trid using the Microsoft Gantt chart visualization, Timeline Basic, & Craydec Timelines. I also tried creating a scatter plot but couldn't quite get that to work either. Ideally I'd like to be able to customize the markers or at least colors.
Any tips, third party visualizations, or tutorial links would be helpful. Thanks much!
This is a simplified version of what I'm looking for created in Excel using a scatter plot.
Solved! Go to Solution.
Hi @CCI_Dev
Based on your description, i create a visual use scatter plot in Power BI, you can refer it.
Sample data
1.Create two calculated columns in table.
Rank = RANKX('Table',[Date],,ASC)
UpdateType = [Update]&" "&[Type]
Then select the UpdateType column and select sort by rank column
2.Create a measure
Measure = 1
Then put the date to x-axis, put the measure to y-axis, and put the UpdateType column to legend.
Then you can set the mark in properities.
Output
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @CCI_Dev
If you want to achieve this, you can create the following field that the update field is blank, but the date field is not, you can refer to the following picture.
Then modifty the measure to the following
Measure = IF(MAX('Table'[Update])=BLANK(),-1,1)
Then set the min and max value of the y-axis.
Output
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you so much for your expertise!
Thank you Yolo! That is exactly what I'm looking for. The only thing would be I need the dates to plot relatively, not evenly spaced out. Is that an option?
Hi @CCI_Dev
If you want to achieve this, you can create the following field that the update field is blank, but the date field is not, you can refer to the following picture.
Then modifty the measure to the following
Measure = IF(MAX('Table'[Update])=BLANK(),-1,1)
Then set the min and max value of the y-axis.
Output
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @CCI_Dev
Based on your description, i create a visual use scatter plot in Power BI, you can refer it.
Sample data
1.Create two calculated columns in table.
Rank = RANKX('Table',[Date],,ASC)
UpdateType = [Update]&" "&[Type]
Then select the UpdateType column and select sort by rank column
2.Create a measure
Measure = 1
Then put the date to x-axis, put the measure to y-axis, and put the UpdateType column to legend.
Then you can set the mark in properities.
Output
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
105 | |
101 | |
79 | |
73 | |
65 |
User | Count |
---|---|
141 | |
107 | |
100 | |
82 | |
74 |