cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

Best visual to show time slipping

Hello together!

 

I want to show the (potential) slipping of release dates in projects in an visual. I have attached an idea, generated in Excel (blue table, shown as image).

 

Which visual, do you can reccomend, to show a slipping in time? If there is not a perfect fit, feel free, to suggest a solution, to show the release date slipping in a different way.

 

Best regards,

ThomasConvert Line into Colums.gif

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Helper I
Helper I

Re: Best visual to show time slipping

Hello v-cherch,

 

Thanks for your help. But I still did not get it working. I have the same problems as in your example (the dates are not in a row -> August bigger June?)

 

BUT, if have tried around with some other visuals and can now recommend: As Timeline

 

Solution Timeline.gif

 

 

 

 

 

 

 

Best regards,

Thomas

 

 

View solution in original post

4 REPLIES 4
Highlighted
Microsoft
Microsoft

Re: Best visual to show time slipping

Hi @Thomas_Eu 

Please check if Scatter chart could help.

https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-scatter

Regards,

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Helper I
Helper I

Re: Best visual to show time slipping

Sorry, but I do not get it. I tried now 30 minutes, but it is impossible for me to generate this picture with the scatter chart.

Scattered Chart.gif

 

 

 

 

 

 

 

 

 

 

 

I understand now, how to pivot/unpivot the original data to get a table which can be used (if all dates need to be in a single columns and the gates in a second column, i can now build this table). But I am still unable to generate the chart.

 

Is anyone able to tell me, which data I have to drop to which field in the scattered chart? Attached, please find my best solution so far 😞

 

Best regards,

Thomas

Scattered Chart2.gif

Highlighted
Microsoft
Microsoft

Re: Best visual to show time slipping

Hi @Thomas_Eu 

You may use 'unpivot columns'.Please check the sample file.

Regards,

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Helper I
Helper I

Re: Best visual to show time slipping

Hello v-cherch,

 

Thanks for your help. But I still did not get it working. I have the same problems as in your example (the dates are not in a row -> August bigger June?)

 

BUT, if have tried around with some other visuals and can now recommend: As Timeline

 

Solution Timeline.gif

 

 

 

 

 

 

 

Best regards,

Thomas

 

 

View solution in original post

Helpful resources

Announcements

August Community Highlights

Check out a full recap of the month!

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

Top Solution Authors