Need help in Stacked Bar and to create a GANTT Chart

[coolshib]

Hello Everyone,

I have the following dataset to create a stacked bar chart.

Project	Task	Project Completion  (%)	Duration (Hrs)	Notes
Project1	Task1 - Phase 1	54%	480	work in Progress
Project1	Task1 - Phase 2	0%	300	will start from 1st july 2024
Project1	Task2	100%	136
Project1	Task3	80%	195	handshake has not happened yet
Project1	Task4	0%	40	New Requirement by the user
Project1	Task5	80%	174	Resource issue
Project2	Task1	72%	60	Resource issue
Project2	Task2	100%	80
Project2	Task3	100%	148
Project2	Task4	100%	72
Project3	Task1	80%	60	Resource issue
Project4	Task1	100%	140
Project5	Task1	100%	64
Project6	Task1	55%	160	On-Track
Project6	Task2	100%	120
Project6	Task3	100%	24
Project6	Task4	100%	148
Project6	Task5	100%	15

I Need to show the completion percentage along with the notes as data value on the chart. I have created a stacked bar chart showing the completion column value as the X axis and mentioning the remarks column value under the detail section in format.

Data value from the remarks column pertaining to Project Status with zero completion should also show on the chart.

Please refer to the screenshot which I have created where the zero completion task showing as blank. Need help on this as well.

I also need to create a GANTT chart based on the above-mentioned dataset.

Many Thanks in Advance.

Regards,

Shib

[Anonymous · Accepted solution]

Hi, @coolshib 

Power BI sometimes filters out or doesn't show categories that don't have data. A workaround is to add a very small value (e.g., 0.01%) to these zero-completion tasks to make them visible on the chart, and then display those values as 0% using a custom format as needed. Or you can try using the BarLabelStyle property to display data labels outside the bar chart for better viewing. For more information about customizing data point labels, see Custom data point labels:

Bar charts in a Power BI paginated report - Power BI | Microsoft Learn

Regarding the Gantt chart, you can go to the more visual to look for

How to Get Your Question Answered Quickly

Best Regards

Yongkang Hua

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly