Hoje faremos uma amostra do novo Power BI Visuals chamado:

Gantt
Published by Microsoft

A Gantt chart is a type of bar chart which illustrates a project timeline or schedule. The Gantt Chart visual shows the Tasks, Start Dates, Durations, % Complete, and Resources for a project. The Gantt Chart visual can be used to show current schedule status using percent-complete shadings and a vertical “TODAY” line. The Legend may be used to group or filter tasks based upon data values.

Vamos comecar:

  • Debaixo de Visualizations, clique Import.

  • Selecione o arquivo Gantt.pbiviz

  • Clique no Gantt icon
  • Campos disponíveis no gráfico
    • Legend
    • Task
    • Start Date
    • Duration
    • % Completion
    • Resource

  • Tabelas utilizadas:
    • Assignments
    • Resources
    • Tasks
  • Colocando os campos nos lugares certos:
    • Legend: Role (Resource)
    • Task: TaskName (Assignments)
    • Start
      Date: AssignmentStartDate (Assignments)
    • Duration: TaskDuration (Tasks)
    • %
      Completion: TaskPercentWorkCompleted (Tasks)
    • Resource: ResourceName (Resources)

  • Coloque outros gráficos e filtros
  • Pronto!

  • Para publicar no Power BI clique em Publish.

  • Acesse o Power BI Report
  • Lembre de clicar em Enable custom visuals.

  • Olha que legal que ficou o gif mostrando o gráfico ao vivo

Power BI Gantt Chart