Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |