Visual Formatting Using On-Object (Preview) Feature in Power BI

By | January 17, 2024

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 visuals.

On-object is an easy approach to constructing and setting up the visual. The on-object feature provides the following formatting options on visuals:

  • Rename titles.
  • Add data labels.
  • Change colour of selected element/title.
  • Change text format of titles.
  • Easy to add data in the fields on Visual itself, etc.

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.

Visual Formatting using On-object Feature in Power BI

Whereas On-Object feature allows user to simply find the formatting options beside the visual itself.

NOTES:

  • This feature currently supports Table, Pie, Donut, Tree map, Card, Bar, Column, Line, Area, Combo and Scatter visuals.
  • This feature is not supported in Power BI service or mobile layout.

Let’s consider a scenario where production supervisor wants to create a production report for manufacturing company. We can construct the visual using On-object feature for production report in Power BI Desktop by following below steps.

Step 1: Navigate to Power BI Desktop app.

Step 2: Navigate to below path to activate On-object feature.

In File -> click on Options and settings -> then click on Options -> then click on Preview Features -> then click on Features -> and put a tick mark in checkbox of “On-object interaction” -> then click OK to turn it ON. Then restart Power BI Desktop app to see the newly added On-object feature.

Visual Formatting using On-object Feature in Power BI

Step 3: Navigate to In Home -> click on Get Data -> then click on Dataverse.

Visual Formatting using On-object Feature in Power BI

 

Step 4: 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.

Visual Formatting using On-object Feature in Power BI

In production report, all the Table columns are visible in Data pane, as shown in below screenshot.

Visual Formatting using On-object Feature in Power BI

Step 5: Add a Pie chart visual in Production report. In Visual, navigate to Add data and build a visual button, and from Build a visual popup menu, easily add data by selecting Product Name field in Legend and Revenue field in Values without drag and drop fields from the data as shown in below screenshot.

Visual Formatting using On-object Feature in Power BIStep 6: In Build a Visual Popup Menu, select toggle Suggest a type to on for automatic selection of the best visual type based on selected data, or select toggle Suggest a type to off for all fields option menu.

Visual Formatting using On-object Feature in Power BI

When we select toggle Suggest a type to on, then Pie Chart Visual is changed to Clustered Bar Chart Visual, as shown in the below screenshot.

Visual Formatting using On-object Feature in Power BIStep 7: 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.

Visual Formatting using On-object Feature in Power BI

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 Bars element, and on click, select the Bars element or Product-wise Revenue title.

Visual Formatting using On-object Feature in Power BI

In formatting, right click on selected Bar element or Axis value element to get a pop-up mini-toolbar and shortcut menu for formatting the selected Bar or Axis value element.

Visual Formatting using On-object Feature in Power BI

We can change the colour of Bar elements as shown in screenshot below.

Visual Formatting using On-object Feature in Power BI

Also, we can change the text format or change text colour of Axis value element, as shown in the below screenshot.

Visual Formatting using On-object Feature in Power BIIn formatting of Clustered bar chart visual, double click on Product-wise Revenue title itself to easily rename the title.

Visual Formatting using On-object Feature in Power BIIn the production report, navigate and click on the Plus button to open the customize pane switcher to easily add and switch between data, format, bookmarks, selection, performance analyzer, and sync slicers.

Visual Formatting using On-object Feature in Power BIIn production report, right click and select Format Canvas, and then navigate to Page Information for Tooltip and Drilltrough setting. These settings are moved to the format page setting in the visualization pane.

Visual Formatting using On-object Feature in Power BI

In the formatting of the clustered bar chart visual, navigate to the Reference line and select Constant Line from the Type dropdown for the Analytics feature. Analytics feature is moved to the format setting of visual from the visualization pane.

Visual Formatting using On-object Feature in Power BI

Conclusion

While creating reports using the On-object feature, we can easily construct and format the visuals. So, working with visuals becomes more convenient and simpler.

Power BI