{"id":8507,"date":"2024-12-11T15:07:17","date_gmt":"2024-12-11T13:07:17","guid":{"rendered":"https:\/\/bitimpulse.com\/?post_type=manual&#038;p=8507"},"modified":"2024-12-11T15:08:48","modified_gmt":"2024-12-11T13:08:48","slug":"pravylo-pidsvitky-znachennya","status":"publish","type":"manual","link":"https:\/\/bitimpulse.com\/en\/manual\/zvit-interaktyvnyj-deshbord\/pidsvitka\/pravylo-pidsvitky-znachennya\/","title":{"rendered":"Format Rule: Value"},"content":{"rendered":"<p>Value can be one of the highlight rules:<\/p>\n<p><a href=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/12\/8_18_1_1-2.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-8537\" src=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/12\/8_18_1_1-2.png\" alt=\"\" width=\"365\" height=\"270\" srcset=\"https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/12\/8_18_1_1-2.png 365w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/12\/8_18_1_1-2-300x222.png 300w\" sizes=\"auto, (max-width: 365px) 100vw, 365px\" \/><\/a><\/p>\n<p>Let us have a look at it on an example of the pivot table:<\/p>\n<p><a href=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/12\/8_18_1_2-2.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-8536\" src=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/12\/8_18_1_2-2.png\" alt=\"\" width=\"1158\" height=\"530\" srcset=\"https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/12\/8_18_1_2-2.png 1158w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/12\/8_18_1_2-2-450x206.png 450w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/12\/8_18_1_2-2-300x137.png 300w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/12\/8_18_1_2-2-768x352.png 768w\" sizes=\"auto, (max-width: 1158px) 100vw, 1158px\" \/><\/a><\/p>\n<p>Let us select the totals of those product categories for which the values of the \u201cSales Amount\u201d measure are more than $ 1 million:<\/p>\n<p><a href=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/12\/8_18_1_3-2.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-8535\" src=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/12\/8_18_1_3-2.png\" alt=\"\" width=\"1161\" height=\"530\" srcset=\"https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/12\/8_18_1_3-2.png 1161w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/12\/8_18_1_3-2-450x205.png 450w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/12\/8_18_1_3-2-300x137.png 300w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/12\/8_18_1_3-2-768x351.png 768w\" sizes=\"auto, (max-width: 1161px) 100vw, 1161px\" \/><\/a><\/p>\n<p>The following form appears:<\/p>\n<p><a href=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/12\/8_18_1_4-2.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-8534\" src=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/12\/8_18_1_4-2.png\" alt=\"\" width=\"292\" height=\"548\" srcset=\"https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/12\/8_18_1_4-2.png 292w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/12\/8_18_1_4-2-240x450.png 240w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/12\/8_18_1_4-2-160x300.png 160w\" sizes=\"auto, (max-width: 292px) 100vw, 292px\" \/><\/a><\/p>\n<p>This form contains the following parameters specific to Pivot:<\/p>\n<ul>\n<li>Format values that are greater than\u2026 \u2013 set value;<\/li>\n<li>Appearance\/Icons \u2013 the \u201cAppearance\u201d tab allows you to choose the predefined background color\/font, the \u201cIcons\u201d tab allows you to add the predefined icon;<\/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 level. 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 \u2013 if you specified the Intersection mode as \u201cSpecific Level\u201d, 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<\/li>\n<\/ul>\n<p>Fill out this form as follows:<\/p>\n<p><a href=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/12\/8_18_1_5-2.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-8533\" src=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/12\/8_18_1_5-2.png\" alt=\"\" width=\"292\" height=\"548\" srcset=\"https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/12\/8_18_1_5-2.png 292w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/12\/8_18_1_5-2-240x450.png 240w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/12\/8_18_1_5-2-160x300.png 160w\" sizes=\"auto, (max-width: 292px) 100vw, 292px\" \/><\/a><\/p>\n<p>As a result, the \u201cPivot\u201d table will look the following:<\/p>\n<p><a href=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/12\/8_18_1_6-2.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-8532\" src=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/12\/8_18_1_6-2.png\" alt=\"\" width=\"945\" height=\"519\" srcset=\"https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/12\/8_18_1_6-2.png 945w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/12\/8_18_1_6-2-450x247.png 450w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/12\/8_18_1_6-2-300x165.png 300w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/12\/8_18_1_6-2-768x422.png 768w\" sizes=\"auto, (max-width: 945px) 100vw, 945px\" \/><\/a><\/p>\n<p>To edit an existing highlight rule, click the \u201cOptions\u201d icon next to the measure:<\/p>\n<p><a href=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/12\/8_18_1_7-2.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-8531\" src=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/12\/8_18_1_7-2.png\" alt=\"\" width=\"333\" height=\"255\" srcset=\"https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/12\/8_18_1_7-2.png 333w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/12\/8_18_1_7-2-300x230.png 300w\" sizes=\"auto, (max-width: 333px) 100vw, 333px\" \/><\/a><\/p>\n<p>In the window that appears, double-click the rule or click an \u201cEdit\u201d button:<\/p>\n<p><a href=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/12\/8_18_1_8-2.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-8530\" src=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/12\/8_18_1_8-2.png\" alt=\"\" width=\"587\" height=\"371\" srcset=\"https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/12\/8_18_1_8-2.png 587w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/12\/8_18_1_8-2-450x284.png 450w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/12\/8_18_1_8-2-300x190.png 300w\" sizes=\"auto, (max-width: 587px) 100vw, 587px\" \/><\/a><\/p>\n<p>To delete the format rule, select the necessary format rule in the list in the \u201cEdit Rules\u201d window and click the \u201cDelete\u201d button:<\/p>\n<p><a href=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/12\/8_18_1_9-2.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-8529\" src=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/12\/8_18_1_9-2.png\" alt=\"\" width=\"587\" height=\"371\" srcset=\"https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/12\/8_18_1_9-2.png 587w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/12\/8_18_1_9-2-450x284.png 450w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/12\/8_18_1_9-2-300x190.png 300w\" sizes=\"auto, (max-width: 587px) 100vw, 587px\" \/><\/a><\/p>\n<p>If necessary, the rule can be temporarily disabled by unchecking the corresponding rule:<\/p>\n<p><a href=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/12\/8_18_1_10-2.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-8528\" src=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/12\/8_18_1_10-2.png\" alt=\"\" width=\"587\" height=\"371\" srcset=\"https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/12\/8_18_1_10-2.png 587w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/12\/8_18_1_10-2-450x284.png 450w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/12\/8_18_1_10-2-300x190.png 300w\" sizes=\"auto, (max-width: 587px) 100vw, 587px\" \/><\/a><\/p>","protected":false},"featured_media":0,"parent":8500,"menu_order":261,"template":"","manuals":[17],"class_list":["post-8507","manual","type-manual","status-publish","hentry","manuals-bat-report"],"_links":{"self":[{"href":"https:\/\/bitimpulse.com\/en\/wp-json\/wp\/v2\/manual\/8507","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\/8500"}],"wp:attachment":[{"href":"https:\/\/bitimpulse.com\/en\/wp-json\/wp\/v2\/media?parent=8507"}],"wp:term":[{"taxonomy":"manuals","embeddable":true,"href":"https:\/\/bitimpulse.com\/en\/wp-json\/wp\/v2\/manuals?post=8507"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}