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:
- Download o Power BI Custom Visual Gantt: https://app.powerbi.com/visuals/
- 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