{"id":327,"date":"2014-02-06T21:10:44","date_gmt":"2014-02-06T15:10:44","guid":{"rendered":"http:\/\/markwheeler.com\/wordpress\/?p=327"},"modified":"2014-02-06T21:10:44","modified_gmt":"2014-02-06T15:10:44","slug":"adding-striplines-with-report-builder","status":"publish","type":"post","link":"https:\/\/markwheeler.com\/?p=327","title":{"rendered":"Adding StripLines with Report Builder"},"content":{"rendered":"<p>I have a Forecast\/Trending Chart that has past and future dates. I needed to denote Today with a vertical StripLine on the chart. (Click on images for larger version.)<BR><br \/>\n<a href=\"http:\/\/markwheeler.com\/wordpress\/wp-content\/uploads\/2014\/02\/Forecast.jpg\" target=\"_new\" rel=\"noopener\"><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/markwheeler.com\/wordpress\/wp-content\/uploads\/2014\/02\/Forecast-300x144.jpg\" alt=\"Forecast\" width=\"300\" height=\"144\" class=\"alignleft size-medium wp-image-328\" \/><\/a><br \/>\n<br clear=\"all\"\/><br \/>\n<br \/>\nYou can add a Marker with an expression easily. <\/p>\n<p><a href=\"http:\/\/markwheeler.com\/wordpress\/wp-content\/uploads\/2014\/02\/MarkerExpress.jpg\" target=\"_new\" rel=\"noopener\"><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/markwheeler.com\/wordpress\/wp-content\/uploads\/2014\/02\/MarkerExpress-300x261.jpg\" alt=\"MarkerExpress\" width=\"300\" height=\"261\" class=\"alignleft size-medium wp-image-329\" \/><\/a><br \/>\n<br clear=\"all\"><br \/>\n<br \/>\nIn your series properties; create an expression for your Marker. In my scenario, it was: =IIF(Fields!Date.value = Today(), &#8220;Star10&#8221;, &#8220;None&#8221;)<br \/>\nThis sets a Star at the Today point on the X axis.<br \/> This is just OK, but I needed to make this a little clearer based on the X-Axis interval.<br \/>\n<br \/>\nTo add a StripLine, click on your X Axis to bring up the properties window and look for the StripLine section under appearance.<br \/>\nOpen the ChartStripLine Collection Editor and Add a new stripline. <br \/>\nGive your line a Color and set BorderStyle to Solid. By default it&#8217;s Default and won&#8217;t show up on your chart.<br \/>\nSet your IntervalOffsetType to Days.<br \/>\nIn IntervalOffset; Use an expression to calculate the number of days between the minimum date in your dataset and Today.<br \/>\nThe expression in this scenario is: =DateDiff(DateInterval.Day,min(Fields!date.Value), Today())+1<Br \/><br \/>\n<BR><br \/>\n<a href=\"http:\/\/markwheeler.com\/wordpress\/wp-content\/uploads\/2014\/02\/StripEditor.jpg\" target=\"_new\" rel=\"noopener\"><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/markwheeler.com\/wordpress\/wp-content\/uploads\/2014\/02\/StripEditor-300x145.jpg\" alt=\"StripEditor\" width=\"300\" height=\"145\" class=\"alignleft size-medium wp-image-330\" \/><\/a><br clear=\"all\"><\/p>\n","protected":false},"excerpt":{"rendered":"<p>I have a Forecast\/Trending Chart that has past and future dates. I needed to denote Today with a vertical StripLine on the chart. (Click on images for larger version.) You can add a Marker with an expression easily. In your series properties; create an expression for your Marker. In my [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"footnotes":""},"categories":[2,10,11],"tags":[90,106,111],"class_list":["post-327","post","type-post","status-publish","format-standard","hentry","category-computer","category-sharepoint","category-software","tag-report-builder","tag-sql-reporting-services","tag-ssrs"],"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/markwheeler.com\/index.php?rest_route=\/wp\/v2\/posts\/327","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/markwheeler.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/markwheeler.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/markwheeler.com\/index.php?rest_route=\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/markwheeler.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=327"}],"version-history":[{"count":0,"href":"https:\/\/markwheeler.com\/index.php?rest_route=\/wp\/v2\/posts\/327\/revisions"}],"wp:attachment":[{"href":"https:\/\/markwheeler.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=327"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/markwheeler.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=327"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/markwheeler.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=327"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}