Skip to main content

Gantt Chart in Power BI

The product team have released a new tile for Power BI which can make a very nice representations of a Gantt Chart. Blow is an example of what the Gantt chart in Power BI Designer.

The tile can be downloaded here.
To use the tile, simply download it and import it to Power BI Desktop.

The tile have a number of fields and measures, if you have trouble figure them out you can download my sample .pbix file here

Comments

  1. It is really a great work and the way in which you are sharing the knowledge is excellent.
    MS Power BI Online Training

    ReplyDelete

  2. I like your post very much. It is very much useful for my research. I hope you to share more info about this. Keep posting!!
    Best Devops Training Institute

    ReplyDelete

Post a Comment

Popular posts from this blog

Azure DevOps - Gantt Chart

It's been a while since my last post - in the past couple of weeks I have played around with some videos of topics I find interesting. One of these topics are a very cool way of displaying a Gantt Chart upon your Azure DevOps board's. Check it out here!

PowerShell results size unlimited/truncated - $FormatEnumerationLimit/Width

Ever experienced the problem where you run a Powershell command and you cannot see the whole result because the result is truncated. Problem: If you for example run the Test-SPsite command you might see something like the following: Site : SPSite Url=http://atlas/pwa Results : { SPSiteHealthResult Status=Passed RuleName="Conflicting Content Types" RuleId=befe203b-a8c0-48c2-b5f0-27c10f9e1622, SPSiteHealthResult Status=FailedWarning RuleName="Customized Files" RuleId=cd839b0d-9707-4950-8fac-f306cb920f6c, SPSiteHealthResult Status=Passed RuleName="Missing Galleries" RuleId=ee967197-ccbe-4c00-88e4-e6fab81145e1, SPSiteHealthResult Status=Passed RuleName="Missing Parent Content Types" RuleId=a9a6769f-7289-4b9f-ae7f-5db4b997d284, SPSiteHealthResult Status=FailedError RuleName="Missing Site Templates" RuleId=5258ccf5-e7d6-4df7-b8ae-12fcc0513ebd, ...

Project Server - PSI - Update enterprise custom field with lookuptable

In Project Server - PSI it should be very fast to assign a new value to a custom field with a lookuptable. However this usually takes a lot of time for me mainly because I never can remember extactly how the field should be updated. That is why i created this post to show how a custom field (assigned to a lookuptable) can be assigned a new value. The biggest issue is that I can't remember how the different entities are connected together. The binding between the project and the lookuptable values are shown in the picture below. There are a number of steps to assign a value to a custom field with a lookuptable.  - Read the project dataset  - Find the custom field; MD_PROP_UID and MD_LOOKUP_TABLE_UID  - Find the ProjectCustomFieldRow with the same MD_PROP_UID  - Find the LookupTable with the same MD_LOOKUP_TABLE_UID  - Find the LookuptableTreesRow with the LT_VALUE_TEXT you want to assign.  - Assign the LT_STRUCT_UID fro...