2022 Week 08 | Power BI: Can you make a Gantt Chart?

Introduction

This week we are creating Gantt Charts in Power BI.

It is not required to do all 4 variations, choose one of the options that interests you the most. Each option increases in time and/or experience level.

Requirements

QUICK MODE

  1. Import data
  2. Import the Microsoft Gantt Chart from AppSource
  3. Place Project Category in the Parent Field well
  4. Place Project in the Task field well
  5. Place Project Stage in the Category field well
  6. Add start and end dates
  7. Format the Gantt Chart to suit

NOT SO QUICK MODE

  1. Import data
  2. Create a Date Table 
  3. Select the Matrix Visual from the visualisations pane
  4. Place Project Category and Project Name in rows
  5. Place Year, Qx and Month from the Date Table in columns
  6. Create a measure that displays the text character “|” for today’s date and blank elsewhere.
  7. Place this measure in values field well
  8. Create a measure that returns 1 for dates between the start and end of a project, 0 for all else
  9. In the conditional formatting options, set the background colour of the cells where the measure in step 8 = 1
  10. (optional) Size the columns equally using this technique
  11. Add a date slicer to the page

LONGER ADVANCED MODE

  1. Complete Steps 1 – 7 of NOT SO QUICK MODE
  2. Create a measure that returns a different hex colour based on Project Stage Value
  3. In the conditional formatting options, set the background colour of the cells to be the field value of the measure from step 2
  4. Create a Legend (TIP : I used a line chart with series values, though there are other alternatives)
  5. Complete steps 10-11 of NOT SO QUICK MODE

IMPOSSI-PUZZLE??

  1. Create a dropdown filter with Project Risk, Project Category, Project Manager and Project Stage as selectable options
  2. Create a Gantt chart with the core matrix visual
  3. Colour the rows according the selected option from step 1
 

Dataset

This week’s data is available to download via the Data Stories Gallery

 

Share

After you finish your workout, share on Twitter using the hashtags #WOW2022 and #PowerBI, and tag @JSBaucke@MMarie, @shan_gsd, @KerryKolosko, and @NerdyWithData. Also make sure to fill out the Submission Tracker so that we can count you as a participant this week in order to track our participation throughout the year. 

Solution

12 thoughts on “2022 Week 08 | Power BI: Can you make a Gantt Chart?”

  1. Hi DS! If you download the GanttData.pbix from the link you posted you’ll find the data in the file there. There isn’t a link to the source data for this week.

  2. Hi,

    Thanks for the tutorial. It’s really helpful. However, I’m having trouble with the columns.

    So I tried changing the MonthOfYear to WeekOfYear, and it won’t show up on the table. Then, I tried removing MonthOfYear and putting it back in, but it seems to fail to show up, as well. Do you why that’s the case?

Leave a Comment

Your email address will not be published. Required fields are marked *

Scroll to Top