How to show percentage completion as data label in Gantt Chart

[Anonymous]

Hi PBI Champs, 

I am using MS Gantt chart and my manager wants to see percentage as a data label. Of course, we can see the percentage completion by hovering the cursor but she wants it as data label so that the completion % is still visible when it is exported to pdf or printed otherwise. When I bring completion percentage into 'Resource' option, Power BI shows it as a fraction (0.1, 0.25 etc.)- see the attached picture. However, I want to see if we can show it as a percentage (10%, 25%, etc.). Please help. Many thanks.

[Alben]

Hello, I had same issue, I made a workaround by creating a new column called % and calculating the progress label and adding the % symbol, you get a text field with the info:

% =

('tbl_Drops'[Progress] * 100)&"%"

In this case I use 'tbl_Drops'[Progress] column on the % Completion field, and I use the newly created % column on the Resource field.

I hope this helps.

[Anonymous]

Running into the same issue.  Has this ever been resolved?

[Anonymous]

No, Veni. I never got a resolution. 😞

[RMDNA]

Hi @Anonymous - just select the Completion Percentage field and in the ribbon and change its display format to Percentage. You can adjust decimals from there

[Anonymous]

Hi RMDNA,

Thanks for your response. It's easy in a table. However, when I pull those percentages into the Microsoft Gantt Chart, it does not show them as percentages. Even when I change the display format like you showed, the Gantt Chart still shows decimal / fractions. Please see the picture i shared.