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.
Go to Solution.
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.
OMG tatasherry! It worked.
I spent all week trying to figure out this.
Thank you so much for the quick response.
Just wanted to point out that the " "Edit Queries" -> transform -> datatype: Decimal Number" fixed the issue.
Power BI Super User, Greg Deckler, explains
Register by September 5 to save $200
Engage and empower students with Power BI!
Continue your learning in our online communities.