Forum Discussion
Represent core project data + delivery timeline
Hi,
I'm looking to present 'core' project data (covering off the what, why and when).
I'm struggling to find a visual in PowerBI that will cover all the requirements. I want to show the data, which I have clear sources for and can import from Excel for now, but then I also want PowerBI to create a simple, one-line GANTT using the start and finish dates I have.
I've been able to show this core info, or to use a GANTT, but not both. I'm looking for advice please on how to bring a view like the attached into PowerBI. Ideally this would be using either core PowerBI functionality or a free visual. I'm not a developer and don't have the skills to customise a visual, but thinking my requirements here are pretty basic.
Couple of other requirements (but nice to have) - user being able to filter by fields 'strategy' and 'area' would be useful, as well as the user being able to sort by cost, so that the highest costing projects were at the top.
A really nice to have would be a universal search bar at the top, so a user could search for keywords in any of the fields shown, and any relevant projects would be shown as a result. Not sure if PowerBI has that functionality.
Appreciate any help and advice here.
Thanks
Hi Anonymous
I think that the closest visualizations that we have to desire are the Gantt charts from Matrix's table. Please take a look at the linked tutorials.https://www.youtube.com/watch?v=SO4mk1H94OA
https://www.youtube.com/watch?v=8pbFvBMT9L8&t=12s
Regarding the search issue, you are right we don't have something generic, but we do have a "search text" slicer you can take from the marketplace and just put up to text columns on the matrix. This visual is free
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
2 Replies
Hi Anonymous
I think that the closest visualizations that we have to desire are the Gantt charts from Matrix's table. Please take a look at the linked tutorials.https://www.youtube.com/watch?v=SO4mk1H94OA
https://www.youtube.com/watch?v=8pbFvBMT9L8&t=12s
Regarding the search issue, you are right we don't have something generic, but we do have a "search text" slicer you can take from the marketplace and just put up to text columns on the matrix. This visual is free
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Thanks that was very helpful. I'm almost there with it.
I'm stuck on trying to get the column values measure to work for quarters rather than days. I have long running projects and this view will need to be at a quarter level. I have a 'Calendar' table that has a quarter column, please can someone help me edit my measure below to work for quarters rather than by days?
Column Values = VAR _startDate = CALCULATE( MIN(Project[Start Date]) , ALL('Calendar') ) VAR _endDate = CALCULATE( MAX(Project[End Date]) , ALL('Calendar') ) VAR _period = MIN('Calendar'[Date]) >= _startDate && MAX('Calendar'[Date]) <= _endDate RETURN IF(_period, 1)