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.
Hi All - I am relatively new to power BI so there may already be a solution to my problem. I am trying to create a visualisation that looks like this
from the below data source. where the timeline above would be dependent on the initiative selected below.
TimelineStart | Timeline End | Initiatives |
01-Aug-17 | 31-Aug-17 | Intiative 1 |
02-Aug-17 | 01-Oct-17 | Intiative 2 |
03-Aug-17 | 01-Nov-17 | Intiative 3 |
04-Aug-17 | 02-Dec-17 | Intiative 4 |
15-Aug-17 | 12-Jan-18 | Intiative 5 |
06-Aug-17 | 02-Feb-18 | Intiative 6 |
07-Aug-17 | 06-Sep-17 | Intiative 7 |
28-Aug-17 | 27-Oct-17 | Intiative 8 |
01-Sep-17 | 30-Nov-17 | Intiative 9 |
10-Sep-17 | 08-Jan-18 | Intiative 10 |
21-Aug-17 | 18-Jan-18 | Intiative 11 |
22-Aug-17 | 18-Feb-18 | Intiative 12 |
02-Oct-17 | 01-Nov-17 | Intiative 13 |
04-Oct-17 | 03-Dec-17 | Intiative 14 |
04-Oct-17 | 02-Jan-18 | Intiative 15 |
05-Oct-17 | 02-Feb-18 | Intiative 16 |
08-Oct-17 | 07-Mar-18 | Intiative 17 |
14-Oct-17 | 12-Apr-18 | Intiative 18 |
14-Oct-17 | 13-Nov-17 | Intiative 19 |
14-Oct-17 | 13-Dec-17 | Intiative 20 |
16-Oct-17 | 14-Jan-18 | Intiative 21 |
14-Oct-17 | 11-Feb-18 | Intiative 22 |
Ive already wasted several days trying to figure this one out - for some reason I am unable to understand these timeline visualisations and how the source data needs to look in order to create the visualisation.
Would much appreciate if someone could point out a visualisation i could use and advise how the source data should look in order to get the visualisation to work.
@Rajbunny maybe its better to discuss what your objective is? are you wanting to slice by month? which visual are you using because there are several that use time, is the the timeline storyteller?
Proud to be a Super User!
My objective is to achieve a visualisation that looks like this image (which is manually created in the most hateful powerpoint)
It shows a timeline in months, positions a start and end indicatior on the time line as well as today's date. Another thing I have to do is change the colour of the arrow based on wether the project is on track or delayed (red, amber, green)
Im trying to use a Gantt chart now - I WAS having issues with duration showing as 1 day regardless (managed to fix duration with a datediff converstion - this requirement is not made clear in the video guide).
I am now struggling with the % complete (showing as 100% for all initiatives, regardless -so I assume once again the data needs to be converted from a percentage to a decimal value). Also, once I have figured out how the data must look to for a visualisation to show anything at all, I still have to learn how to customise the look and feel as well as determine how i can set start and end dates for both the timeline (jul 17-jul18) start and end dates for the selected initiative (currently only shows the latter) - it will be devastating to learn in the end that it can not create the visualisation I am after. First prise would be a recommendation to use a custom visualisation that someone knows will do the job along with advice on how the source data should look (to avoid more time waste). Second prise is advice on how to set up the source data to get the Gantt custom visualisation to get as close to expected as possible
@Rajbunny what about this one?
Proud to be a Super User!
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 |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |