How to change the % in Tooltip and How to fix the percentage to 100% if completed?

[Hopeisgood1]

Hi all:

I have 2 issues....

1) the tooltip is using the .48% instead of 48%.

Whereas the table has it formatted correctly....

And for the Tooltip Settings, it's only for the Date Format....

2) I am not sure HOW to do the DAX calculation between 2 dates without going over 100% if it's completed? 

ProgressPercentage = DIVIDE ((TODAY() - [TaskStartDate]), ([TaskEndDate] - [TaskStartDate]))

[V-yubandi-msft]

Hi @Hopeisgood1 ,

the place  of "sum of progress percentage"  of  "%completion" , don't use any calculation, just select "No Calculation" 

If it doesn't work, confirm the visual name as well as the dummy data if possible.

Thanks for your contribution @lbendlin .

Thanks..

[Hopeisgood1]

That is what I have...

And my work is not allowing us uploading files outside of its realm 😞 So here you go for the bottom info.

Here's the dummy data 

and the set up in Power BI for Gantt

[V-yubandi-msft · Accepted solution]

Hi @Hopeisgood1 ,

Please try to use the below calculated column DAX query. 

ProgressPercentage = ROUND(MIN(1,DIVIDE ((TODAY() - [TaskStartDate]), ([TaskEndDate] - [TaskStartDate]))),1)

and to make the bar darker you need to you need to Turn OFF the TASK COMPLETION option  if it is ON.

Thanks...

[Hopeisgood1]

THANK YOU!!!! 

[lbendlin]

ProgressPercentage = MIN(1,DIVIDE ((TODAY() - [TaskStartDate]), ([TaskEndDate] - [TaskStartDate])))

[Hopeisgood1]

That works perfect!!! 

How do I fix the tooltips, though? I need to figure out the bars, though, as it's not filling up the darker color!

[lbendlin]

You would need to provide some more details. What's the definition of "% Completion" ?  Is that a measure?

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.

Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

[Hopeisgood1]

Hi Ibendlin,

Sorry, my work is not allowing me to upload files outside of their approval list...

However, this is technically one thing - the Progress Percentage - You fixed the DAX piece (issue 1). 

The % Completion (aka the ProgressPercentage) is the percentage of how much is completed in a task. The calculation came from the one you assisted me with earlier. 

The % of the tooltip is also reflecting the values from the % Completion (aka the ProgressPercentage) in the snapshot. (issue 2)

I found some solutions. All but one are fixed.

100% is fixed but the ones less than 100% has 2 decimals in it (below)

I need it formated at 49%, NOT 49.44%....

That's the only thing I need help fixing.

Thank you,

Holly