Need visual suggestion with dates & milestones for projects and breaching alert if crossing dead lin

[Anonymous]

Hello,

I am looking for some help with respective to the visuals.

Requirements:

1) Project name & Dates of starting and dead line.

2) Visual should alert if the dead line date is breached.

3) Should also include the milestones like attached in snapshot.

Please do let me know if there is any visual that can help with respetive to the above requirement.

[KBO]

Hi @Anonymous ,

can I ask for which data source do you need this. Sometimes there are really good templates for a few data source types. Otherwise may be the gantt chart by lingaro can help...a alert is possible but I guess in the Power BI Report Server Version not that easy as in the Power BI Service....

Best,

Kathrin

If this post has helped you, please give it a thumbs up!
Did I answer your question? Mark my post as a solution!

[Anonymous]

Data source is azuredevops boards

[KBO]

Hi @Anonymous ,

after use goolge I found this for example: https://ppmblog.org/2019/06/14/devops-power-bi-reporting/

I guess there some more reports for this :).

On which point do you stuck exactly? Do you have sample data? May be I can help 🙂

Best,

Kathrin

If this post has helped you, please give it a thumbs up!
Did I answer your question? Mark my post as a solution!

[Anonymous]

Sample data:

Feature name   Start date                  Target date   User story duedate(Consider as milestone)

x                           10/10/2020           20/10/2020         12/10/2020                                                                                                              x                            10/10/2020          20/10/2020          14/10/2020 

x                             10/10/2020         20/10/2020           16/10/2020 

y                             15/10/2020         30/10/2020            17/10/2020

y                              15/10/2020         30/10/2020            25/10/2020

[KBO]

HI @Anonymous ,

here is a simillar topic I guess 🙂

https://community.powerbi.com/t5/DAX-Commands-and-Tips/Help-with-DAX-changing-colors/td-p/724154

you can change the color of your visual based on a DAX measure -> https://data-marc.com/2018/12/06/format-your-colors-based-on-advanced-controls/

Best,

Kathrin

If this post has helped you, please give it a thumbs up!
Did I answer your question? Mark my post as a solution!

[Anonymous]

Right now i am able to capture the time line in features but capturing the milestones like user stories & alerting/changing the color if the feature dead line date/target date is breached is some thing that i am stuck