Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
som_mukherjee
Frequent Visitor

Combine tasks in a single chart on PowerBI Gantt 2.2.3

Hello Community, 

I am beginner to PowerBI and loving it so far! 

 

However, I am stuck with a peculiar problem while constructing a Gantt Chart using Gantt 2.2.3.

Everything works well, except the fact that "tasks" with similar names are grouped separately rather than a single contiguous visualisation. 

 

For example, there are two entries for Name2 instead of a combined entry under Project 2. The same probelm persists with Name3 as well.

 

How it looks:

Picture1.png

 

How I want it to look:

 

Picture2.png

 

I shall apreciate any help in this regards.

 

Cheers! 

1 ACCEPTED SOLUTION
AllisonKennedy
Super User
Super User

@som_mukherjee  There is a setting under General to 'Group Tasks', turn this on: 

 

AllisonKennedy_0-1625972977188.png

 

https://community.powerbi.com/t5/Desktop/Splitting-bars-on-a-gantt-chart/m-p/398521/highlight/true#M... 


Please @mention me in your reply if you want a response.

Copying DAX from this post? Click here for a hack to quickly replace it with your own table names

Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C

I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com

View solution in original post

4 REPLIES 4
som_mukherjee
Frequent Visitor

@AllisonKennedy  Thank you so much for the earlier tip. It worked well. But there has been an issue with clubbing tasks together.

I will appreciate any insights on that as well.

Query2.png

 

Is there a way by which I can get both the "overview" and combined tasks?

Thanks ! 🙂

Not that I'm aware of, you could try building your own view in Charticulator https://charticulator.com/ 


Please @mention me in your reply if you want a response.

Copying DAX from this post? Click here for a hack to quickly replace it with your own table names

Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C

I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com

AllisonKennedy
Super User
Super User

@som_mukherjee  There is a setting under General to 'Group Tasks', turn this on: 

 

AllisonKennedy_0-1625972977188.png

 

https://community.powerbi.com/t5/Desktop/Splitting-bars-on-a-gantt-chart/m-p/398521/highlight/true#M... 


Please @mention me in your reply if you want a response.

Copying DAX from this post? Click here for a hack to quickly replace it with your own table names

Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C

I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com

Thank you so much, it worked like a charm! 🙂

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel1

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.