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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

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
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.