Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Suppose I have the following data structure (from an Excel file but I guess this doesn't really matter here)
Name | MS1 | MS2 | MS3 |
Task 1 | 15.03.2021 | 30.06.2021 | 30.10.2021 |
Task 2 | 01.02.2021 | 01.04.2021 | 31.08.2021 |
Task 3 | 01.02.2021 | 30.06.2021 | 15.09.2021 |
I would like to create a visual as a gantt chart that
I am of course happy to transform the data in any way needed.
However so far I am simply not able to get it to work. Can't figure out the right data format and / or which data to put into which fields of the above mentioned visuals. Also this date hierachy puzzles me - in some attempts, when at least showing some milestones (never more than one per line) I usually end up with "earliest date" for those...
If all fails I would also accept to have each milestone on a single line grouped by the Task name.
Any hints would be appreciated.
Edit: not sure why the table layout is messed up like this, should look like this
Solved! Go to Solution.
Please check out the As Timeline visual. I unpivoted your data and tried that. Key thing is to uncheck the Stacked option in the formatting options.
Regards,
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
@mahoneypat @Ashish_Mathur thanks for your replies! Unpivot of my table indeed did the trick, especially together with the "As Timeline" visual.
Please check out the As Timeline visual. I unpivoted your data and tried that. Key thing is to uncheck the Stacked option in the formatting options.
Regards,
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Can someone help me with this? I have as a visual 1.5 and gantt chart visuals imported and i have a gazillion dates I need on the same x-axis / line, similar to M1,M2,M3 but I cant get it to work for me. can i get a detailed step by step?
Hi Pat
Which timeline visual you have used?
Thanks
Hazari
Looks like the "As Timeline" custom viz is no longer available?
I've looked here, but get a 404 on the download: https://blog.pragmaticworks.com/power-bi-custom-visuals-as-timeline
Also obviously looked via get custom viz in Power BI too
Hi,
In the Query Editor, right click on the Name column and select "Unpivot other columns".
Hope this helps.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |