Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Hello All
I am working on analysis of all the Projects done in our business.
I came across the Gantt Chart - Custom Visual and it fits perfectly in the case I wanted to.
But I am facing a small difficulty to color the bars in Gantt custom visuals.
As you can see that on the top there are 3 status:
1. Completed
2. In Progress
3. Planned
All three have different color coding. What I want is that if the Status="Completed"the I want to color them by "Green"color else all other status will be "a Different color(can be any random color".
Please help me in this formatting.
Regards
Shubham Sharma
Hi @Anonymous,
I made a sample of a file and have one column with the status when I add it to the the Gant in the legend, however what I think you want is to be able to choose the colours right?
In this visual this is not possible problaby you can contact the author at pbicvsupport@microsoft.com and aks for that option.
Regards,
Mfelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi
I am trying to do this also and struggling to find a way to select different colours based on the status of the project.
Any help appreciated.
Graham
If you get stuck with a visual don't forget you can get lots of flexibility from R visuals.
https://www.r-bloggers.com/gantt-charts-in-r-using-plotly/
https://davetang.org/muse/2017/02/03/gantt-chart-using-r/
https://rstudio-pubs-static.s3.amazonaws.com/106401_8efca65e9be14404b27e4779d393fb4f.html
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
72 | |
70 | |
55 | |
37 | |
31 |
User | Count |
---|---|
83 | |
64 | |
63 | |
49 | |
45 |