How to create a Gantt chart in Power BI (with a free visual!) 

Sure, glad it was helpful!

Awesome!

Best I can do is to the right of the bar - if you drop a field into the "Resource" well you can put text there. You can't customize a whole lot with this, but there are other Gantts made with Deneb where if you can do some coding you're able to control display more.

You can append two data tables in Power Query as long as the column names are exactly the same in Power Query. Add a custom column to both that labels each table before appending (the formula is just =“some label here”) if you want to differentiate them in the report. If I remember, the category coloring for the MS Gantt visual seemed to not be functional when I tried it out… it’s possible that it was just me though so you should give it a try! I’m not at a computer right now but will look at again tomorrow. The visuals program manager at Microsoft said the Gantt is on the list for overhauling eventually but it will be a while (they collect feedback on #PBICoreVisuals on LinkedIn).

I appended my data tables and it worked. Now I want to find a way to group sub-tasks under tasks. @@bi-ome

Yes, you could do this with bookmarks. I have a video doing something similar, but for a different visual setting. You essentially create a visual and bookmark for each setting configuration (weekly, quarterly/etc), then use the bookmarks to show/hide the related visual. Here’s the tutorial: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-e5yWWYboPaU.htmlsi=XPU2Xkh-NlxgFps2

The way to do this is to essentially create two visuals (or however many different settings combinations you want) configure one for each of those settings combinations, then show/hide them with the bookmarks using the visual visibility setting in the bookmark. The bookmarks only control data filters, page selection, or visual visibility, not settings, that's why we have to go that route. I did a video here where we swap visuals with bookmarks, so if you combine the techniques from both it should work the way you want! ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-UNTtCPs8pQA.html

@@bi-ome great! Thanks so much again, I think this will also help me put two different flow charts within the same page, and having buttons to toggle between them. Thank you so much!!

No, but it looks like the xViz custom visual may allow that with their task hierarchy? ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-wkVwzwmoCas.html

My guess is that it’s getting confused on items where the duration comes out to be 0 days… it still wants to show a bar, so it gives it the only length increment it can, which is whole numbers. It’s not designed to show tasks that have no duration. You could try showing those as milestones instead, which I think use their own date column (with just a single date), and blank-out the start and end on it? It is very much a bare bones visual, hoping they improve it. Microsoft just hired David Bacci on their visuals team (who made an awesome Deneb Gantt I did a video on), so I’m hopeful that he does an improved version eventually!

@bi-ome thank you very much.

I don't think so! I tried and had the same problem. You might try a different Gantt, like Davide Bacci's Deneb template, if you want to be able to customize the little bits. That one is pure JSON code, so you can just search for where the timeline text is and just edit the font size.

@@bi-ome excellent, thank you! (I have that video opened in a tab waiting to be watched lol! Guess it's time to revisit. Thanks again.

It will show that way if you collapse the grouping... so I guess you could collapse them by default and let people open them to see details? There's not a setting that will toggle the group bar while it's expanded that I see.

I had no luck getting the milestones or the color categorization working - I am not sure they DO work. If you need extra functionality, there’s a Deneb template by David Bacci that’s open source, or there are other paid Gantt visuals-

Not this particular visual, I think Bas’ channel has one that simulates a Gantt using a table visual that would be square-corned though (channel is called How to Power BI).

I don’t think you can modify the functionality of this visual in that way, you’d have to use a different visual. This one is very limited; I only chose it for a demo because it’s Microsoft’s and widely accessible

@@bi-ome ok thanks

It depends on where you have the filter set. You can configure the bookmark to update "only selected visuals" in its settings and only select your Gantt when you update the bookmark - that will let you ignore anything in that slicer. I would recommend using a slicer over the filter pane in this case

@@bi-omeIt Worked! Thanks!!

This visual is very basic - there have been hints that something better will be released eventually, but if you want customization you have to go with Deneb or custom visuals currently :/

Not with this visual, but other visuals have more configuration options.

If you are having trouble getting to the app store, you can also download the file with the "get it now" button here, and import it from a file instead of from appsource: appsource.microsoft.com/en-us/product/power-bi-visuals/wa104380765?tab=overview

You can add days (or months or years etc) to any date, it doesn't have to be an existing date column. The trick is inputting your date in the way PQ expects it - there is an example here: learn.microsoft.com/en-us/powerquery-m/date-adddays

Depends what you mean by responsive - that toggle is usually for things like collapsing axis on small visuals and entirely changing how it displays when smaller. Everything in PBI should scale up and down with screen size as long as you have the view for the page set to "fit to width" or "fit to screen". You can't change how this particular visual behaves, but it should do the latter--

Not sure what you mean?

I found the milestones to be really lackluster in this visual, but if you post details I can try to help-

I would also like help on Milestones. Using your information, Fro example, how could you add a milestone for example End of Fiscal Year where you could use a specific date and maybe the description "EOFY". Would you need to set an additional column "milestone" or something like that? @@bi-ome . Thank you.

If you have milestones or other more complex task data to visualize, I would recommend this Gantt instead: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-tOhAxulPAoc.htmlsi=O4oLKnCT9mXFyGqa The milestone visualization in the MS visual seems broken to me (it could really use some updates...)