% Completion is completely wrong

[MaxKHK]

Dear MS team, I am not sure why but I face some very weird behavior with gantt chart visual related to completion rate shading.

Please find below to examples.

1) Completion rate as you see is 100% (it is a decimal, formated as %, dropped into completion pane). But somehow the task is not fully colored! (previous tasks are all actually 100% complete too)

2) Completion rate is 0%, but gantt is again somehow randomly colored:

What's worse, I can see completely random behavior in this sense - for some subsets of data it works just fine, but for some others I get this odd behavior.

[uve]

hello @MaxKHK, could you please share a sample report to reproduce the issue?

[MaxKHK]

Dear Uve,

Please find below the example of such report. Will be much appreciated if you could point me to some workaround for this problem. UPDATE: file is removed to avoid public access

[kenneth817]

Hi Max any chance of a resolution as I am facing the same issue

[helen508light]

We had investigated this issue and now preparing release, which will reach prod in 2 weeks

[MaxKHK]

Dear Helen,

Thank you for the good news! Unfortunately, this issue started to appear yesterday in our production environment looking really ugly in production dashboard which is used by some of our really high level stakeholders. It will be really great if you could either:

• Let me know if there is any quick and dirty workaround for this issue which we can implement right away by manipulating the data we feed into visual
• Or if you can drop the fixed visual as a standalone file which we can just import into the dashboard without waiting for two weeks until it goes into production from your side that will work for us as well.

It will be really helpful since, sadly, it will be really difficult for us to just wait couple of weeks without doing anything. Thank you!

[KorhonenSami]

Dear all,

We are facing this same issue and it really bothers our scheduling in fabrication line. If You are releasing some kind of fix package earlier than after two long weeks, please send me it also. This is wrecking my nerve. I assume You made some updates while ago and similar issues were appearing also that time (at least we were facing those).

BR Sami

[kenneth817]

Absolutely unheard of , a bug causing a serious issue which can be easily fixed by rolling back the version,however the production team says we have a solution but wait 2 weeks.id suggest every one go and lower the rating of the visualization and voice your concerns there

[uve]

due to big impact on users, we reverted GanttChart to v2.0.2. @kenneth817, @KorhonenSami, @MaxKHK Please check your reports, and let me know if the bug is gone.

[MaxKHK]

Dear @uve,

Could you please let me know how to roll it back? I need to delete the visual from the dashboard, and import it again from Market place?

[kenneth817]

I am still facing the same issue..doesn't seem to have rolled back for me.

[kenneth817]

@uve .same issue..doesn't seem to have been rectified

[kenneth817]

It still shows version 2.2.2.0 for me

[MaxKHK]

Same for me. Marketplace still shows 2.2.2.0 as available version

[helen508light]

Market place will show you the latest version. See the powerbi web service or desktop: version have to be changed to 2.0.2 If u are still facing with 2.2.2 there - please, clear cache

[kenneth817]

Working fine for me now.thanks @helen508light

[MaxKHK]

Thank you so much Elena, it worked perfect for us and your quick turnaround is much appreciated.

But for my future understanding, how does it gets refreshed? Our dashboards are deployed in PowerBI report server (not the microsoft one, we have our own server which serves PBI for us). How does the refresh of custom visuals work? Can we disable automatic update of the visuals (to avoid such unexpected breaking changes in visuals without testing them out ourselves first)?

[KorhonenSami]

Thanks a lot, works nicely!

[EricChristoph]

Market place will show you the latest version. See the powerbi web service or desktop: version have to be changed to 2.0.2 If u are still facing with 2.2.2 there - please, clear cache

Can you point me to a reference on how to "clear cache" and revert to the previous version? I'm sure it's simple but I don't know how to uninstall a visual or select which version I am installing, I just know how to import from Marketplace.

[helen508light]

for PowerBI Desktop delete all the files except User.zip in C:\Users\Akvelon\AppData\Local\Microsoft\Power BI Desktop

[helen508light]

@MaxKHK Now the current version received to any powerBI services from our cdn, you can't choose manually which version to use and can't disable automatic updates. But you able to choose which version of each visual would be rendered using Organizational visuals https://docs.microsoft.com/en-us/power-bi/power-bi-custom-visuals-organization (this way has more requirements)

[EricChristoph]

for PowerBI Desktop delete all the files except User.zip in C:\Users\Akvelon\AppData\Local\Microsoft\Power BI Desktop

Thank you so much! But then what? If I re-install Power BI it will just load the latest version; same with the Gantt visual. How do I install the patch released a few hours ago?

[helen508light]

@EricChristoph
You shouldn't anything except clearing the cache(if version is still 2.2.2 for you). We had reverted visual to previous stable version 2.0.2. We hadn't relealesed the new patch on prod yet. In general(if you don't clear cache) visual version on Desktop and web service syncs with cdn after 1 hour after visual had been reverted on cdn.

[EricChristoph]

@helen508light Again, thanks for your help with this!

So I cleared the cache, and re-installed the Visual. What I'm expecting to see is a field value for "Milestones", but all I'm getting is this:

Is this right?

[helen508light]

@EricChristoph have you changed GUID of the visual manually? which version does visual's icon shows after mouse on? could you provide you report\package to investigate this issue?

[EricChristoph]

• I have not changed the GUID of the visual manually
• Icon shows version 1.14.3? I just downloaded this from the marketplace yesterday.
• I can easily generate a demo dataset and report and send that. Where do I send it?

[helen508light]

For milestones feature usage visual version should be 2.0.0 or greater. Do you use visual from organization store? (in general, visual version is 2.0.2 now)

[EricChristoph]

I don't know what an organization store is. I download Power BI, then I access the marketplace. Is there another way to get visualizations?

[helen508light]

It's really strange behavior. If you try to choose "import from market place" it should give you gantt 2.0.2

[helen508light]

Another way is only to build package from source from this repo by yourself(with changed GUID in pbiviz.json)

[helen508light]

Hi @EricChristoph @kenneth817 @MaxKHK @KorhonenSami Is this issue still reprodicable for you? Please note, we had released new 2.2.3 version on prod

[kenneth817]

Hi Helen..sorry for the late response...Visualization is working fine for me.Thank you so much for your assistance

[KorhonenSami]

Hello Helen, I think it works quite fine. Just wondering some features:

There You can see that in some projects days off are shown and in some cases those are not visible - maybe some bug? I have no idea why days off are not visible in every line, they sure should be.

Second thing is that when I use parent items, I would like to see the completion of whole project. I think this is not possible at the moment. That would be really neat feature and at least a really huge benefit for us. In some situations we need to know were we are going in those small steps and in some times it is important to see the whole picture. This is not easy task off course. For example in our case we are using man power / hours to estimate the completion percentage and there might be situation were task 1 has lots of hours and many emplyees working with it and in task 2 just few ours with one emplyee. So if task 1 is done 50 % and task 2 10 %, it does not mean that overall project is already 30 % done but rather 45 %.

Third thing that popped in my mind; I noticed that completion-% was (or is, not sure at the moment) shown wrong if we put the "days off" on. We had to multiple the completion percentage by 5/7 (work days / whole week) and then it was shown correctly. I´m not sure if You have already fixed this error.

BR Sami

[helen508light]

@KorhonenSami Thank you for feedback We had issue related to completion calculation with "days off" on. Could you please also provide a report that reproducing issue with completion and days off?