how to remove duplicates the Names in Gantt chart

[Anonymous]

Hi,

I want to display the Name should be once like the user doesn't like to see the Name duplicates(2 times or 3 times...)

For example "A person" as to display only once in Name field even though they are doing multiple jobs in Gantt chart like below

[v-yalanwu-msft]

Hi, @Anonymous ;

Is your problem solved?  If so, kindly mark the proper reply as a solution to help others having the similar issue and close the case. If not, let me know and I'll try to help you further.

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[v-yalanwu-msft]

Hi, @Anonymous ;

Indeed, this is by design, and both functions cannot be owned at the same time. This is a custom import visual, and if you can, you can create a new column that shows only the first Person value.

Column = 
IF([job]=
CALCULATE(MIN('Table'[job]),ALLEXCEPT('Table','Table'[name])),[name]," ")

Then final show:

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi Yalan,

Thanks for the measure. I tried this for example report it worked but not for my report still, some more is displaying.  

[v-yalanwu-msft]

Hi, @Anonymous ;

It's a pity that since I don't have your report, it's not clear why? If you can, can you share the file after removing sensitive information?

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

I am giving Ranking for the job and I kept that column in the category area and customer details also in the name area, I will check how to share after removing the sensitive information 

[Anonymous]

Thank you so much for immediate reply.

[v-yalanwu-msft]

Hi， @Anonymous ；

Solved: How to upload PBI in Community - Microsoft Power BI Community

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[v-yalanwu-msft]

Hi, @Anonymous ;

You could set it as follow:

1.orginal visual.

2.adjust it.

3.the final show:

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

please help,

Thanks

[Anonymous]

Thanks for the solution, but for different jobs  we need to use different colours for bar formatting.

If we on Hierarchy layout then we can't use different colours

Thanks.