{"id":37090,"date":"2024-01-17T10:26:50","date_gmt":"2024-01-17T04:56:50","guid":{"rendered":"https:\/\/www.inogic.com\/blog\/?p=37090"},"modified":"2024-01-17T10:26:50","modified_gmt":"2024-01-17T04:56:50","slug":"visual-formatting-using-on-object-preview-feature-in-power-bi","status":"publish","type":"post","link":"https:\/\/www.inogic.com\/blog\/2024\/01\/visual-formatting-using-on-object-preview-feature-in-power-bi\/","title":{"rendered":"Visual Formatting Using On-Object (Preview) Feature in Power BI"},"content":{"rendered":"<p><a href=\"https:\/\/www.inogic.com\/services\/microsoft-power-platform\/microsoft-power-bi-data-visualisation\/\" target=\"_blank\" rel=\"noopener\">Microsoft Power BI<\/a> is an interactive tool to visualize the data. Using Power BI, users can interact with the data in order to develop business reports and make business-level decisions. Power BI visuals are tools, and they are picture illustrations of data. Microsoft introduced <strong>the on-object<\/strong> feature, i.e., an easy way to construct and setup visuals.<\/p>\n<p><strong>On-object<\/strong> is an easy approach to constructing and setting up the visual. <strong>The on-object<\/strong> feature provides the following formatting options on visuals:<\/p>\n<ul>\n<li>Rename titles.<\/li>\n<li>Add data labels.<\/li>\n<li>Change colour of selected element\/title.<\/li>\n<li>Change text format of titles.<\/li>\n<li>Easy to add data in the fields on Visual itself, etc.<\/li>\n<\/ul>\n<p>Initially, Power BI desktop had a Formatting panel for each visual, and users had to navigate to that panel to find the required properties of the visual for formatting, as shown in the below screenshot.<\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-37091\" style=\"border: 1px solid #0a0a0a; padding: 1px; margin: 1px;\" src=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/01\/1Visual-Formatting-using-On-object-Feature-in-Power-BI.jpeg\" alt=\"Visual Formatting using On-object Feature in Power BI\" width=\"1110\" height=\"656\" srcset=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/01\/1Visual-Formatting-using-On-object-Feature-in-Power-BI.jpeg 1110w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/01\/1Visual-Formatting-using-On-object-Feature-in-Power-BI-300x177.jpeg 300w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/01\/1Visual-Formatting-using-On-object-Feature-in-Power-BI-1024x605.jpeg 1024w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/01\/1Visual-Formatting-using-On-object-Feature-in-Power-BI-768x454.jpeg 768w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/01\/1Visual-Formatting-using-On-object-Feature-in-Power-BI-660x390.jpeg 660w\" sizes=\"(max-width: 1110px) 100vw, 1110px\" \/><\/p>\n<p>Whereas <strong>On-Object<\/strong> feature allows user to simply find the formatting options beside the visual itself.<\/p>\n<p>NOTES:<\/p>\n<ul>\n<li>This feature currently supports Table, Pie, Donut, Tree map, Card, Bar, Column, Line, Area, Combo and Scatter visuals.<\/li>\n<li>This feature is not supported in Power BI service or mobile layout.<\/li>\n<\/ul>\n<p>Let\u2019s consider a scenario where production supervisor wants to create a production report for manufacturing company. We can construct the visual using <strong>On-object<\/strong> feature\u00a0for production report in Power BI Desktop by following below steps.<\/p>\n<p><strong>Step 1<\/strong>: Navigate to Power BI Desktop app.<\/p>\n<p><strong>Step 2<\/strong>: Navigate to below path to activate <strong>On-object<\/strong> feature.<\/p>\n<p>In\u00a0<strong>File <\/strong>-&gt; click on <strong>Options and settings <\/strong>-&gt; then click on <strong>Options -&gt;<\/strong> then click on <strong>Preview<\/strong> <strong>Features -&gt;<\/strong> then click on <strong>Features -&gt;<\/strong> and put a tick mark in checkbox of \u201c<strong>On-object interaction\u201d<\/strong> <strong>-&gt;<\/strong> then click <strong>OK <\/strong>to turn it ON. Then restart Power BI Desktop app to see the newly added <strong>On-object<\/strong> feature.<\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-37092\" style=\"border: 1px solid #0a0a0a; padding: 1px; margin: 1px;\" src=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/01\/2Visual-Formatting-using-On-object-Feature-in-Power-BI.jpeg\" alt=\"Visual Formatting using On-object Feature in Power BI\" width=\"1638\" height=\"998\" srcset=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/01\/2Visual-Formatting-using-On-object-Feature-in-Power-BI.jpeg 1638w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/01\/2Visual-Formatting-using-On-object-Feature-in-Power-BI-300x183.jpeg 300w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/01\/2Visual-Formatting-using-On-object-Feature-in-Power-BI-1024x624.jpeg 1024w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/01\/2Visual-Formatting-using-On-object-Feature-in-Power-BI-768x468.jpeg 768w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/01\/2Visual-Formatting-using-On-object-Feature-in-Power-BI-1536x936.jpeg 1536w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/01\/2Visual-Formatting-using-On-object-Feature-in-Power-BI-660x402.jpeg 660w\" sizes=\"(max-width: 1638px) 100vw, 1638px\" \/><\/p>\n<p><strong>Step 3<\/strong>: Navigate to In\u00a0<strong>Home <\/strong>-&gt; click on <strong>Get Data <\/strong>-&gt; then click on <strong>Dataverse<\/strong><strong>.<\/strong><\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-37107\" style=\"border: 1px solid #0a0a0a; padding: 1px; margin: 1px;\" src=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/01\/3Visual-Formatting-using-On-object-Feature-in-Power-BI-1.jpeg\" alt=\"Visual Formatting using On-object Feature in Power BI\" width=\"1601\" height=\"824\" srcset=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/01\/3Visual-Formatting-using-On-object-Feature-in-Power-BI-1.jpeg 1601w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/01\/3Visual-Formatting-using-On-object-Feature-in-Power-BI-1-300x154.jpeg 300w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/01\/3Visual-Formatting-using-On-object-Feature-in-Power-BI-1-1024x527.jpeg 1024w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/01\/3Visual-Formatting-using-On-object-Feature-in-Power-BI-1-768x395.jpeg 768w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/01\/3Visual-Formatting-using-On-object-Feature-in-Power-BI-1-1536x791.jpeg 1536w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/01\/3Visual-Formatting-using-On-object-Feature-in-Power-BI-1-660x340.jpeg 660w\" sizes=\"(max-width: 1601px) 100vw, 1601px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p><strong>Step 4<\/strong>: Log in with your user credentials to establish connection with Dataverse. Then select appropriate Environment and select the Table as per your requirement, and then either load the data directly or transform data.<\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-37106\" style=\"border: 1px solid #0a0a0a; padding: 1px; margin: 1px;\" src=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/01\/4Visual-Formatting-using-On-object-Feature-in-Power-BI.jpeg\" alt=\"Visual Formatting using On-object Feature in Power BI\" width=\"1610\" height=\"974\" srcset=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/01\/4Visual-Formatting-using-On-object-Feature-in-Power-BI.jpeg 1610w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/01\/4Visual-Formatting-using-On-object-Feature-in-Power-BI-300x181.jpeg 300w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/01\/4Visual-Formatting-using-On-object-Feature-in-Power-BI-1024x619.jpeg 1024w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/01\/4Visual-Formatting-using-On-object-Feature-in-Power-BI-768x465.jpeg 768w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/01\/4Visual-Formatting-using-On-object-Feature-in-Power-BI-1536x929.jpeg 1536w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/01\/4Visual-Formatting-using-On-object-Feature-in-Power-BI-660x399.jpeg 660w\" sizes=\"(max-width: 1610px) 100vw, 1610px\" \/><\/p>\n<p>In production report, all the Table columns are visible in <strong>Data <\/strong>pane, as shown in below screenshot.<\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-37105\" style=\"border: 1px solid #0a0a0a; padding: 1px; margin: 1px;\" src=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/01\/5Visual-Formatting-using-On-object-Feature-in-Power-BI.jpeg\" alt=\"Visual Formatting using On-object Feature in Power BI\" width=\"1920\" height=\"850\" srcset=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/01\/5Visual-Formatting-using-On-object-Feature-in-Power-BI.jpeg 1920w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/01\/5Visual-Formatting-using-On-object-Feature-in-Power-BI-300x133.jpeg 300w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/01\/5Visual-Formatting-using-On-object-Feature-in-Power-BI-1024x453.jpeg 1024w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/01\/5Visual-Formatting-using-On-object-Feature-in-Power-BI-768x340.jpeg 768w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/01\/5Visual-Formatting-using-On-object-Feature-in-Power-BI-1536x680.jpeg 1536w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/01\/5Visual-Formatting-using-On-object-Feature-in-Power-BI-660x292.jpeg 660w\" sizes=\"(max-width: 1920px) 100vw, 1920px\" \/><\/p>\n<p><strong>Step 5<\/strong>: Add a Pie chart visual in Production report. In Visual, navigate to <strong>Add data and build a visual<\/strong> button, and from <strong>Build a visual<\/strong> popup menu, easily <strong>add data<\/strong> by selecting <strong>Product Name<\/strong> field in Legend and <strong>Revenue<\/strong> field in Values without drag and drop fields from the data as shown in below screenshot.<\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-37104\" style=\"border: 1px solid #0a0a0a; padding: 1px; margin: 1px;\" src=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/01\/6Visual-Formatting-using-On-object-Feature-in-Power-BI.jpeg\" alt=\"Visual Formatting using On-object Feature in Power BI\" width=\"1382\" height=\"858\" srcset=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/01\/6Visual-Formatting-using-On-object-Feature-in-Power-BI.jpeg 1382w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/01\/6Visual-Formatting-using-On-object-Feature-in-Power-BI-300x186.jpeg 300w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/01\/6Visual-Formatting-using-On-object-Feature-in-Power-BI-1024x636.jpeg 1024w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/01\/6Visual-Formatting-using-On-object-Feature-in-Power-BI-768x477.jpeg 768w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/01\/6Visual-Formatting-using-On-object-Feature-in-Power-BI-660x410.jpeg 660w\" sizes=\"(max-width: 1382px) 100vw, 1382px\" \/><strong>Step 6:<\/strong> In <strong>Build a Visual<\/strong> Popup Menu, select toggle <strong>Suggest a type<\/strong> to on for automatic selection of the best visual type based on selected data, or select toggle <strong>Suggest a type<\/strong> to off for all fields option menu.<\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-37103\" style=\"border: 1px solid #0a0a0a; padding: 1px; margin: 1px;\" src=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/01\/7Visual-Formatting-using-On-object-Feature-in-Power-BI.jpeg\" alt=\"Visual Formatting using On-object Feature in Power BI\" width=\"1303\" height=\"677\" srcset=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/01\/7Visual-Formatting-using-On-object-Feature-in-Power-BI.jpeg 1303w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/01\/7Visual-Formatting-using-On-object-Feature-in-Power-BI-300x156.jpeg 300w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/01\/7Visual-Formatting-using-On-object-Feature-in-Power-BI-1024x532.jpeg 1024w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/01\/7Visual-Formatting-using-On-object-Feature-in-Power-BI-768x399.jpeg 768w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/01\/7Visual-Formatting-using-On-object-Feature-in-Power-BI-660x343.jpeg 660w\" sizes=\"(max-width: 1303px) 100vw, 1303px\" \/><\/p>\n<p>When we select toggle <strong>Suggest a type<\/strong> to on, then <strong>Pie Chart <\/strong>Visual is changed to <strong>Clustered Bar Chart<\/strong> Visual, as shown in the below screenshot.<\/p>\n<p><strong> <img decoding=\"async\" class=\"alignnone size-full wp-image-37102\" style=\"border: 1px solid #0a0a0a; padding: 1px; margin: 1px;\" src=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/01\/8Visual-Formatting-using-On-object-Feature-in-Power-BI.jpeg\" alt=\"Visual Formatting using On-object Feature in Power BI\" width=\"1303\" height=\"677\" srcset=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/01\/8Visual-Formatting-using-On-object-Feature-in-Power-BI.jpeg 1303w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/01\/8Visual-Formatting-using-On-object-Feature-in-Power-BI-300x156.jpeg 300w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/01\/8Visual-Formatting-using-On-object-Feature-in-Power-BI-1024x532.jpeg 1024w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/01\/8Visual-Formatting-using-On-object-Feature-in-Power-BI-768x399.jpeg 768w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/01\/8Visual-Formatting-using-On-object-Feature-in-Power-BI-660x343.jpeg 660w\" sizes=\"(max-width: 1303px) 100vw, 1303px\" \/><\/strong><strong>Step 7:<\/strong> In the clustered bar chart visual, right-click to get a popup menu and select the Format option, or double-click on the visual for formatting.<\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-37101\" style=\"border: 1px solid #0a0a0a; padding: 1px; margin: 1px;\" src=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/01\/9Visual-Formatting-using-On-object-Feature-in-Power-BI.jpeg\" alt=\"Visual Formatting using On-object Feature in Power BI\" width=\"1058\" height=\"644\" srcset=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/01\/9Visual-Formatting-using-On-object-Feature-in-Power-BI.jpeg 1058w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/01\/9Visual-Formatting-using-On-object-Feature-in-Power-BI-300x183.jpeg 300w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/01\/9Visual-Formatting-using-On-object-Feature-in-Power-BI-1024x623.jpeg 1024w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/01\/9Visual-Formatting-using-On-object-Feature-in-Power-BI-768x467.jpeg 768w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/01\/9Visual-Formatting-using-On-object-Feature-in-Power-BI-660x402.jpeg 660w\" sizes=\"(max-width: 1058px) 100vw, 1058px\" \/><\/p>\n<p>In the formatting of the clustered bar chart visual, the borders of the visual turn blue, and on hover, the region is displayed to format the <strong>Bars<\/strong> element, and on click, select the <strong>Bars<\/strong> element or <strong>Product-wise Revenue<\/strong> title.<\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-37100\" style=\"border: 1px solid #0a0a0a; padding: 1px; margin: 1px;\" src=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/01\/10Visual-Formatting-using-On-object-Feature-in-Power-BI.jpeg\" alt=\"Visual Formatting using On-object Feature in Power BI\" width=\"994\" height=\"594\" srcset=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/01\/10Visual-Formatting-using-On-object-Feature-in-Power-BI.jpeg 994w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/01\/10Visual-Formatting-using-On-object-Feature-in-Power-BI-300x179.jpeg 300w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/01\/10Visual-Formatting-using-On-object-Feature-in-Power-BI-768x459.jpeg 768w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/01\/10Visual-Formatting-using-On-object-Feature-in-Power-BI-660x394.jpeg 660w\" sizes=\"(max-width: 994px) 100vw, 994px\" \/><\/p>\n<p>In formatting, right click on selected <strong>Bar<\/strong> element or <strong>Axis value<\/strong> element to get a pop-up mini-toolbar and shortcut menu for formatting the selected <strong>Bar<\/strong> or <strong>Axis value<\/strong> element.<\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-37099\" style=\"border: 1px solid #0a0a0a; padding: 1px; margin: 1px;\" src=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/01\/11Visual-Formatting-using-On-object-Feature-in-Power-BI.jpeg\" alt=\"Visual Formatting using On-object Feature in Power BI\" width=\"1428\" height=\"622\" srcset=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/01\/11Visual-Formatting-using-On-object-Feature-in-Power-BI.jpeg 1428w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/01\/11Visual-Formatting-using-On-object-Feature-in-Power-BI-300x131.jpeg 300w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/01\/11Visual-Formatting-using-On-object-Feature-in-Power-BI-1024x446.jpeg 1024w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/01\/11Visual-Formatting-using-On-object-Feature-in-Power-BI-768x335.jpeg 768w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/01\/11Visual-Formatting-using-On-object-Feature-in-Power-BI-660x287.jpeg 660w\" sizes=\"(max-width: 1428px) 100vw, 1428px\" \/><\/p>\n<p>We can change the colour of <strong>Bar<\/strong> elements as shown in screenshot below.<\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-37098\" style=\"border: 1px solid #0a0a0a; padding: 1px; margin: 1px;\" src=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/01\/12Visual-Formatting-using-On-object-Feature-in-Power-BI.jpeg\" alt=\"Visual Formatting using On-object Feature in Power BI\" width=\"1303\" height=\"677\" srcset=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/01\/12Visual-Formatting-using-On-object-Feature-in-Power-BI.jpeg 1303w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/01\/12Visual-Formatting-using-On-object-Feature-in-Power-BI-300x156.jpeg 300w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/01\/12Visual-Formatting-using-On-object-Feature-in-Power-BI-1024x532.jpeg 1024w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/01\/12Visual-Formatting-using-On-object-Feature-in-Power-BI-768x399.jpeg 768w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/01\/12Visual-Formatting-using-On-object-Feature-in-Power-BI-660x343.jpeg 660w\" sizes=\"(max-width: 1303px) 100vw, 1303px\" \/><\/p>\n<p>Also, we can change the text format or change text colour of <strong>Axis value<\/strong> element, as shown in the below screenshot.<\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-37097\" style=\"border: 1px solid #0a0a0a; padding: 1px; margin: 1px;\" src=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/01\/13Visual-Formatting-using-On-object-Feature-in-Power-BI.jpeg\" alt=\"Visual Formatting using On-object Feature in Power BI\" width=\"964\" height=\"584\" srcset=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/01\/13Visual-Formatting-using-On-object-Feature-in-Power-BI.jpeg 964w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/01\/13Visual-Formatting-using-On-object-Feature-in-Power-BI-300x182.jpeg 300w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/01\/13Visual-Formatting-using-On-object-Feature-in-Power-BI-768x465.jpeg 768w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/01\/13Visual-Formatting-using-On-object-Feature-in-Power-BI-660x400.jpeg 660w\" sizes=\"(max-width: 964px) 100vw, 964px\" \/>In formatting of Clustered bar chart visual, double click on <strong>Product-wise Revenue<\/strong> title itself to easily rename the title.<\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-37096\" style=\"border: 1px solid #0a0a0a; padding: 1px; margin: 1px;\" src=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/01\/14Visual-Formatting-using-On-object-Feature-in-Power-BI.jpeg\" alt=\"Visual Formatting using On-object Feature in Power BI\" width=\"1073\" height=\"611\" srcset=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/01\/14Visual-Formatting-using-On-object-Feature-in-Power-BI.jpeg 1073w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/01\/14Visual-Formatting-using-On-object-Feature-in-Power-BI-300x171.jpeg 300w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/01\/14Visual-Formatting-using-On-object-Feature-in-Power-BI-1024x583.jpeg 1024w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/01\/14Visual-Formatting-using-On-object-Feature-in-Power-BI-768x437.jpeg 768w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/01\/14Visual-Formatting-using-On-object-Feature-in-Power-BI-660x376.jpeg 660w\" sizes=\"(max-width: 1073px) 100vw, 1073px\" \/>In the production report, navigate and click on the <strong>Plus button<\/strong> to open the\u00a0<strong>customize pane switcher<\/strong> to easily add and switch between data, format, bookmarks, selection, performance analyzer, and sync slicers.<\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-37095\" style=\"border: 1px solid #0a0a0a; padding: 1px; margin: 1px;\" src=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/01\/15Visual-Formatting-using-On-object-Feature-in-Power-BI.jpeg\" alt=\"Visual Formatting using On-object Feature in Power BI\" width=\"1318\" height=\"676\" srcset=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/01\/15Visual-Formatting-using-On-object-Feature-in-Power-BI.jpeg 1318w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/01\/15Visual-Formatting-using-On-object-Feature-in-Power-BI-300x154.jpeg 300w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/01\/15Visual-Formatting-using-On-object-Feature-in-Power-BI-1024x525.jpeg 1024w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/01\/15Visual-Formatting-using-On-object-Feature-in-Power-BI-768x394.jpeg 768w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/01\/15Visual-Formatting-using-On-object-Feature-in-Power-BI-660x339.jpeg 660w\" sizes=\"(max-width: 1318px) 100vw, 1318px\" \/>In production report, right click and select <strong>Format Canvas,<\/strong> and then navigate to <strong>Page Information<\/strong> for <strong>Tooltip <\/strong>and<strong> Drilltrough<\/strong> setting. These settings are moved to the format page setting in the visualization pane.<\/p>\n<p><strong><img decoding=\"async\" class=\"alignnone size-full wp-image-37094\" style=\"border: 1px solid #0a0a0a; padding: 1px; margin: 1px;\" src=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/01\/16Visual-Formatting-using-On-object-Feature-in-Power-BI.jpeg\" alt=\"Visual Formatting using On-object Feature in Power BI\" width=\"1100\" height=\"634\" srcset=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/01\/16Visual-Formatting-using-On-object-Feature-in-Power-BI.jpeg 1100w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/01\/16Visual-Formatting-using-On-object-Feature-in-Power-BI-300x173.jpeg 300w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/01\/16Visual-Formatting-using-On-object-Feature-in-Power-BI-1024x590.jpeg 1024w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/01\/16Visual-Formatting-using-On-object-Feature-in-Power-BI-768x443.jpeg 768w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/01\/16Visual-Formatting-using-On-object-Feature-in-Power-BI-660x380.jpeg 660w\" sizes=\"(max-width: 1100px) 100vw, 1100px\" \/><br \/>\n<\/strong><\/p>\n<p>In the formatting of the clustered bar chart visual, navigate to the <strong>Reference line<\/strong> and select <strong>Constant Line<\/strong> from the<strong>\u00a0Type <\/strong>dropdown<strong>\u00a0<\/strong>for the<strong>\u00a0Analytics feature<\/strong>. <strong>Analytics feature<\/strong> is moved to the format setting of visual from the visualization pane.<\/p>\n<p><strong> <img decoding=\"async\" class=\"alignnone size-full wp-image-37093\" style=\"border: 1px solid #0a0a0a; padding: 1px; margin: 1px;\" src=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/01\/17Visual-Formatting-using-On-object-Feature-in-Power-BI.jpeg\" alt=\"Visual Formatting using On-object Feature in Power BI\" width=\"932\" height=\"486\" srcset=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/01\/17Visual-Formatting-using-On-object-Feature-in-Power-BI.jpeg 932w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/01\/17Visual-Formatting-using-On-object-Feature-in-Power-BI-300x156.jpeg 300w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/01\/17Visual-Formatting-using-On-object-Feature-in-Power-BI-768x400.jpeg 768w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/01\/17Visual-Formatting-using-On-object-Feature-in-Power-BI-660x344.jpeg 660w\" sizes=\"(max-width: 932px) 100vw, 932px\" \/><\/strong><\/p>\n<h2><strong>Conclusion<\/strong><\/h2>\n<p>While creating reports using the <strong>On-object<\/strong> feature, we can easily construct and format the visuals. So, working with visuals becomes more convenient and simpler.<\/p>\n<p><a href=\"https:\/\/bit.ly\/47rjpj5\" target=\"_blank\" rel=\"noopener\"><img decoding=\"async\" class=\"alignnone  wp-image-37025\" src=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/01\/Power-BI.gif\" alt=\"Power BI\" width=\"739\" height=\"211\" \/><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Microsoft Power BI is an interactive tool to visualize the data. Using Power BI, users can interact with the data in order to develop business reports and make business-level decisions. Power BI visuals are tools, and they are picture illustrations of data. Microsoft introduced the on-object feature, i.e., an easy way to construct and setup\u2026 <span class=\"read-more\"><a href=\"https:\/\/www.inogic.com\/blog\/2024\/01\/visual-formatting-using-on-object-preview-feature-in-power-bi\/\">Read More &raquo;<\/a><\/span><\/p>\n","protected":false},"author":11,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[45],"tags":[2823],"class_list":["post-37090","post","type-post","status-publish","format-standard","hentry","category-power-bi","tag-microsoft-power-bi"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/posts\/37090","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/users\/11"}],"replies":[{"embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/comments?post=37090"}],"version-history":[{"count":0,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/posts\/37090\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/media?parent=37090"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/categories?post=37090"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/tags?post=37090"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}