cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Val Frequent Visitor
Frequent Visitor

How to show % completion on Gantt chart

My % completion is showing 100% when it is actually 51% or more. When I set it to 50% or less, it shows 0%.

 

Please let me know how to fix this issue and show correct % completion on my visual.

 

Thank you.

 

Val

1 ACCEPTED SOLUTION

Accepted Solutions
tatasherry Frequent Visitor
Frequent Visitor

Re: How to show % completion on Gantt chart

Hi @Val ,

 

I guess it is because you set the "Data type" as "Whole Number".

 

The way to fix it : Modeling  -> datatype: Decimal Number -> %

 

If still does not work, go to "Edit Queries" -> transform -> datatype: Decimal Number

 

 

Please choose as a solution if it helps.

3 REPLIES 3
tatasherry Frequent Visitor
Frequent Visitor

Re: How to show % completion on Gantt chart

Hi @Val ,

 

I guess it is because you set the "Data type" as "Whole Number".

 

The way to fix it : Modeling  -> datatype: Decimal Number -> %

 

If still does not work, go to "Edit Queries" -> transform -> datatype: Decimal Number

 

 

Please choose as a solution if it helps.

Val Frequent Visitor
Frequent Visitor

Re: How to show % completion on Gantt chart

OMG tatasherry! It worked.

I spent all week trying to figure out this.

Thank you so much for the quick response.

 

Val

Val Frequent Visitor
Frequent Visitor

Re: How to show % completion on Gantt chart

Just wanted to point out that the " "Edit Queries" -> transform -> datatype: Decimal Number" fixed the issue.

 

Thanks.

 

Val

Helpful resources

Announcements
GregDeckler

How to Get Your Question Answered Quickly

Power BI Super User, Greg Deckler, explains

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Ideas
Users Online
Currently online: 84 members 1,520 guests
Please welcome our newest community members: