{"id":7013,"date":"2024-08-13T16:11:17","date_gmt":"2024-08-13T13:11:17","guid":{"rendered":"https:\/\/bitimpulse.com\/?post_type=manual&#038;p=7013"},"modified":"2024-08-13T16:11:17","modified_gmt":"2024-08-13T13:11:17","slug":"pravylo-pidsvitky-linijna-diagrama","status":"publish","type":"manual","link":"https:\/\/bitimpulse.com\/en\/manual\/stvorennya-interaktyvnogo-deshborda\/pidsvitka\/pravylo-pidsvitky-linijna-diagrama\/","title":{"rendered":"Format Rule: Bar"},"content":{"rendered":"<p>The \u201cBar\u201d format condition allows you to visualize numeric values using bars. You can also paint bars corresponding to positive and negative values using different colors:<\/p>\n<p><a href=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/08\/9_21_8_1-2.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7034\" src=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/08\/9_21_8_1-2.png\" alt=\"\" width=\"165\" height=\"250\" \/><\/a><\/p>\n<p>This dialog allows you to change the following options specific to the \u201cBar\u201d format condition:<\/p>\n<p><a href=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/08\/9_21_8_2-2.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7033\" src=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/08\/9_21_8_2-2.png\" alt=\"\" width=\"296\" height=\"628\" srcset=\"https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/08\/9_21_8_2-2.png 296w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/08\/9_21_8_2-2-212x450.png 212w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/08\/9_21_8_2-2-141x300.png 141w\" sizes=\"auto, (max-width: 296px) 100vw, 296px\" \/><\/a><\/p>\n<ul>\n<li>Min\/Max \u2013 by default, lengths of the shortest and longest bars correspond to minimum and maximum values, respectively. If necessary, you can specify values corresponding to the shortest and longest bars manually. To do this, change the type of minimum\/maximum value from \u201cAutomatic\u201d to \u201cNumber or Percent\u201d, and specify the required values;<\/li>\n<li>Style Settings \u2013 \u201cStyle Settings\u201d and \u201cNegative Style Settings\u201d allow you to specify style settings used to color data bars corresponding to positive and negative values, respectively;<\/li>\n<li>Intersection mode \u2013 the level at which the highlight will be The levels can be as follows:\n<ul>\n<li>Auto \u2013 identifies the default For the Pivot dashboard item, Auto identifies the \u201cFirst Level\u201d;<\/li>\n<li>First level \u2013 first level values are used to apply conditional formatting;<\/li>\n<li>Last level \u2013 the last level values are used to apply conditional formatting;<\/li>\n<li>All levels \u2013 all pivot data cells are used to apply conditional formatting;<\/li>\n<li>Specific level \u2013 values from the specific level are used to apply conditional<\/li>\n<\/ul>\n<\/li>\n<li>Row\/Column dimension &#8211; if you specified the Intersection mode as Specific Level, use the \u201cRow dimension\u201d and \u201cColumn dimension\u201d combo boxes to set the specific level;<\/li>\n<li>Apply to \u2013 to which element (measure, hierarchy) of the Pivot table the conditional formatting should be applied;<\/li>\n<li>Apply to row\/column \u2013 apply to the entire row \/ to the entire column;<\/li>\n<li>Allow negative axis \u2013 the \u201cAllow negative axis\u201d option allows you to specify whether negative data bars are displayed in the direction opposite to the positive data bars;<\/li>\n<li>Draw axis \u2013 the \u201cDraw axis\u201d option specifies whether to draw the vertical axis between positive and negative data bars;<\/li>\n<li>Show bar only \u2013 the \u201cShow bar only\u201d option specifies whether to show bars without corresponding values.<\/li>\n<\/ul>\n<p>Let us look at this type of highlight on the example of the \u201cPivot\u201d table:<\/p>\n<p><a href=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/08\/9_21_8_3-2.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7032\" src=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/08\/9_21_8_3-2.png\" alt=\"\" width=\"769\" height=\"382\" srcset=\"https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/08\/9_21_8_3-2.png 769w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/08\/9_21_8_3-2-450x224.png 450w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/08\/9_21_8_3-2-300x149.png 300w\" sizes=\"auto, (max-width: 769px) 100vw, 769px\" \/><\/a><\/p>\n<p>Let us add a highlight rule for the \u201cReseller Gross Profit\u201d measure:<\/p>\n<p><a href=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/08\/9_21_8_4-2.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7031\" src=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/08\/9_21_8_4-2.png\" alt=\"\" width=\"769\" height=\"410\" srcset=\"https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/08\/9_21_8_4-2.png 769w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/08\/9_21_8_4-2-450x240.png 450w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/08\/9_21_8_4-2-300x160.png 300w\" sizes=\"auto, (max-width: 769px) 100vw, 769px\" \/><\/a><\/p>\n<p>Fill out the form as follows:<\/p>\n<p><a href=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/08\/9_21_8_5-2.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-7030 alignnone\" src=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/08\/9_21_8_5-2.png\" alt=\"\" width=\"296\" height=\"641\" srcset=\"https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/08\/9_21_8_5-2.png 296w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/08\/9_21_8_5-2-208x450.png 208w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/08\/9_21_8_5-2-139x300.png 139w\" sizes=\"auto, (max-width: 296px) 100vw, 296px\" \/><\/a> <a href=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/08\/9_21_8_7-2.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-7029 alignnone\" src=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/08\/9_21_8_7-2.png\" alt=\"\" width=\"296\" height=\"641\" srcset=\"https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/08\/9_21_8_7-2.png 296w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/08\/9_21_8_7-2-208x450.png 208w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/08\/9_21_8_7-2-139x300.png 139w\" sizes=\"auto, (max-width: 296px) 100vw, 296px\" \/><\/a><\/p>\n<p>As a result, we will get the following table:<\/p>\n<p><a href=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/08\/9_21_8_8.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7028\" src=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/08\/9_21_8_8.png\" alt=\"\" width=\"521\" height=\"342\" srcset=\"https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/08\/9_21_8_8.png 521w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/08\/9_21_8_8-450x295.png 450w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/08\/9_21_8_8-300x197.png 300w\" sizes=\"auto, (max-width: 521px) 100vw, 521px\" \/><\/a><\/p>","protected":false},"featured_media":0,"parent":6908,"menu_order":526,"template":"","manuals":[18],"class_list":["post-7013","manual","type-manual","status-publish","hentry","manuals-bat-desktop"],"_links":{"self":[{"href":"https:\/\/bitimpulse.com\/en\/wp-json\/wp\/v2\/manual\/7013","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/bitimpulse.com\/en\/wp-json\/wp\/v2\/manual"}],"about":[{"href":"https:\/\/bitimpulse.com\/en\/wp-json\/wp\/v2\/types\/manual"}],"up":[{"embeddable":true,"href":"https:\/\/bitimpulse.com\/en\/wp-json\/wp\/v2\/manual\/6908"}],"wp:attachment":[{"href":"https:\/\/bitimpulse.com\/en\/wp-json\/wp\/v2\/media?parent=7013"}],"wp:term":[{"taxonomy":"manuals","embeddable":true,"href":"https:\/\/bitimpulse.com\/en\/wp-json\/wp\/v2\/manuals?post=7013"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}