Projects with milestones in timeline

[Anonymous]

Hi Community,

ineed your help to the following problem in Power BI.

I try to add each project including the six milestones in one line like the example.

for each milestone the is a start and an end date.

can someone tell me if something like this is possible in power bi?

example

[pranit828]

Hi @Anonymous 

Every logical view is possible in Power BI.

Are you game for achieving the end result. If yes then it is possible.

[amitchandak · Accepted solution]

@Lachsforelle12, there are few options.

Gantt Chart, visual project timeline
https://appsource.microsoft.com/en/product/power-bi-visuals/WA104380765?tab=Overview
https://www.mpug.com/articles/how-to-create-an-amazing-gantt-chart-in-power-bi/
https://blog.pragmaticworks.com/power-bi-custom-visuals-as-timeline
https://www.youtube.com/watch?v=SO4mk1H94OA
https://xviz.com/visuals/gantt-chart/

Another is the color code matrix using a conditional format

Create a measure like this and use it with the field option in conditional format

color =
switch ( true(),
FIRSTNONBLANK(Table[commodity],"NA") ="commodity1" && sum(Table[Value]) >500,"lightgreen",
FIRSTNONBLANK(Table[commodity],"NA") ="commodity2" && sum(Table[Value]) >1000,"lightgreen",
/// Add more conditions
"red"
)

https://radacad.com/dax-and-conditional-formatting-better-together-find-the-biggest-and-smallest-num...
https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting#color-by-color-values

[Anonymous]

Hi, here is my first try with asTimeLine.

why does my timeline start at 2010 - that squeezes my milestones together..

do you have a tip here?

[v-lionel-msft]

Hi @Anonymous ,

Which visual is this, a custom visual?

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.