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,
I've been trying to create the following timeline, but I cannot find the correct visual to use that fills my needs:
My data is structured in the following way:
Name | Start | Progress Phase 1 | Delay Phase 1 | Milestone 1 | Progress Phase 2 | Delay Phase 2 | Milestone 2 | Progress Phase 3 | Delay Phase 3 | Finish |
Project 1 | 1/1/20 | 5 | 3 | 1/9/20 | 3 | 1 | 1/13/20 | 6 | 2 | 1/21/20 |
Project 2 | 1/5/20 | 4 | 10 | 1/19/20 | 3 | 0 | 1/23/20 | 7 | 0 | 1/29/20 |
Project 3 | 1/10/20 | 5 | 0 | 1/125/20 | 4 | 0 | 1/19/20 | 6 | 0 | 1/25/20 |
etc (600+ lines)
These are my requirements:
Does anyone know a visual I can use to achieve this?
Thank you in advance!
Kind regards,
BH
Hello There,
Just wondering if you managed to get a solution to your problem. I am having a similar kind of dataset and using Adwise Visual, however, it is not plotting my Milestones. Please do share if you have any possible solution.
Best Regards
Additional info:
- Adwise Gantt chart is looking promissing https://www.adwise.cz/adwise-roadmap/?lang=en
- xViz is not for free for companies (120€/user/year, min 5 users)
- As Timeline do not have fancy marks for milestones
- So far a saw, only the MAQ Gantt allows that when a line is selected in the chart, that this line is filtering other items on the page.
@BHpowerbi , you have few project visual or matrix with same conditional formatting for both fond and background
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/
Create a color measure
Color = if(FIRSTNONBLANK(Table[Year],2014) <=2016 && AVERAGE(Sales[Sales Amount])<170
,"lightgreen",if(FIRSTNONBLANK(Table[Year],2014)>2018,"red","yellow"))
Color sales = if([Sales Today] -[sales yesterday]>0,"green","red")
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"
)
And use with conditional formatting "Field value" option
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
which charts have you tried?
can you share some dummy data?
Proud to be a Super User!
I have tried the following visuals:
An example data set is provided here:
https://docs.google.com/spreadsheets/d/1r13KHszY2OOhqD2YjO95R9csTW4k3FxAAizhE18J_8k/edit?usp=sharing
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 |
---|---|
112 | |
100 | |
76 | |
74 | |
49 |
User | Count |
---|---|
146 | |
108 | |
106 | |
90 | |
62 |