{"id":10061,"date":"2015-09-04T08:21:01","date_gmt":"2015-09-04T08:21:01","guid":{"rendered":"https:\/\/blogs.msdn.microsoft.com\/visualstudioalm\/2015\/09\/04\/general-availability-of-work-item-trend-and-rollup-reporting-in-power-bi\/"},"modified":"2022-08-02T02:41:59","modified_gmt":"2022-08-02T10:41:59","slug":"general-availability-of-work-item-trend-and-rollup-reporting-in-power-bi","status":"publish","type":"post","link":"https:\/\/devblogs.microsoft.com\/devops\/general-availability-of-work-item-trend-and-rollup-reporting-in-power-bi\/","title":{"rendered":"General Availability of Work Item Trend and Rollup Reporting in Power BI"},"content":{"rendered":"<p>Today, a few short weeks after our initial release of the work item reporting capabilities in the Visual Studio Online Power BI Connector, we are happy to announce the general availability of trend and rollup reporting capabilities. Starting today you can do things like create sprint burndown charts based on story points, effort, size or remaining work.<\/p>\n<p><img decoding=\"async\" title=\"image\" style=\"border-left-width: 0px;border-right-width: 0px;border-bottom-width: 0px;padding-top: 0px;padding-left: 0px;padding-right: 0px;border-top-width: 0px\" border=\"0\" alt=\"image\" src=\"https:\/\/devblogs.microsoft.com\/devops\/wp-content\/uploads\/sites\/6\/2015\/09\/8508.image_thumb_4D6B13E9.png\" width=\"461\" height=\"352\" \/><\/p>\n<p>These capabilities let you trend any data in the model over time.<\/p>\n<p>The rollup capability allows you to provide summary counts of work items in different states under epics, features, or stories. With rollup counts you can get a count of estimated, completed, or remaining work,.<\/p>\n<p>The following example shows a count of tasks by state for each of the user stories under their parent features.<\/p>\n<p><img decoding=\"async\" title=\"SNAGHTML30536e1e\" style=\"border-left-width: 0px;border-right-width: 0px;border-bottom-width: 0px;padding-top: 0px;padding-left: 0px;padding-right: 0px;border-top-width: 0px\" border=\"0\" alt=\"SNAGHTML30536e1e\" src=\"https:\/\/devblogs.microsoft.com\/devops\/wp-content\/uploads\/sites\/6\/2015\/09\/6076.SNAGHTML30536e1e_thumb_6D19EDB1.png\" width=\"706\" height=\"267\" \/><\/p>\n<p>With the release of these capabilities we have redone the out of the box report to provide a more complete view of your data including a new Open Bug Status report page with bug trends:<\/p>\n<p><img decoding=\"async\" title=\"SNAGHTML30761362\" style=\"border-left-width: 0px;border-right-width: 0px;border-bottom-width: 0px;padding-top: 0px;padding-left: 0px;padding-right: 0px;border-top-width: 0px\" border=\"0\" alt=\"SNAGHTML30761362\" src=\"https:\/\/devblogs.microsoft.com\/devops\/wp-content\/uploads\/sites\/6\/2015\/09\/2804.SNAGHTML30761362_thumb_3AB61A32.png\" width=\"706\" height=\"480\" \/><\/p>\n<p>If you haven\u2019t tried out the Power BI reporting features, give it a try now \u2013 it\u2019s free! <a href=\"https:\/\/www.visualstudio.com\/en-us\/get-started\/report\/connect-vso-pbi-vs\" target=\"_blank\" rel=\"noopener\">Instructions on getting started can be found here<\/a>.<\/p>\n<p>Please note that you will need to re-create your connection to Visual Studio Online in order to take advantage of the new model \u2013 models will not upgrade in place. Help documentation can be found here for these two new features:<\/p>\n<p><a href=\"https:\/\/msdn.microsoft.com\/Library\/vs\/alm\/Report\/powerbi\/create-trend-charts\">https:\/\/msdn.microsoft.com\/Library\/vs\/alm\/Report\/powerbi\/create-trend-charts<\/a><\/p>\n<p><a href=\"https:\/\/msdn.microsoft.com\/Library\/vs\/alm\/Report\/powerbi\/create-rollup-charts\">https:\/\/msdn.microsoft.com\/Library\/vs\/alm\/Report\/powerbi\/create-rollup-charts<\/a><\/p>\n<p>Additional documentation will be released next week detailing the model and some anomalies people may experience because of the model design. As always, feedback is welcome \u2013 either on the new capabilities or on the new help documentation.<\/p>\n<p>Thanks,<\/p>\n<p>Jeff Levinson<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Today, a few short weeks after our initial release of the work item reporting capabilities in the Visual Studio Online Power BI Connector, we are happy to announce the general availability of trend and rollup reporting capabilities. Starting today you can do things like create sprint burndown charts based on story points, effort, size or [&hellip;]<\/p>\n","protected":false},"author":170,"featured_media":45953,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[1],"tags":[],"class_list":["post-10061","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-devops"],"acf":[],"blog_post_summary":"<p>Today, a few short weeks after our initial release of the work item reporting capabilities in the Visual Studio Online Power BI Connector, we are happy to announce the general availability of trend and rollup reporting capabilities. Starting today you can do things like create sprint burndown charts based on story points, effort, size or [&hellip;]<\/p>\n","_links":{"self":[{"href":"https:\/\/devblogs.microsoft.com\/devops\/wp-json\/wp\/v2\/posts\/10061","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/devblogs.microsoft.com\/devops\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/devblogs.microsoft.com\/devops\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/devops\/wp-json\/wp\/v2\/users\/170"}],"replies":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/devops\/wp-json\/wp\/v2\/comments?post=10061"}],"version-history":[{"count":0,"href":"https:\/\/devblogs.microsoft.com\/devops\/wp-json\/wp\/v2\/posts\/10061\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/devops\/wp-json\/wp\/v2\/media\/45953"}],"wp:attachment":[{"href":"https:\/\/devblogs.microsoft.com\/devops\/wp-json\/wp\/v2\/media?parent=10061"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/devops\/wp-json\/wp\/v2\/categories?post=10061"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/devops\/wp-json\/wp\/v2\/tags?post=10061"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}