Uploaded January 2025 | Updated September 2026, 2 weeks ago
Discover why it’s time to embrace On Object Formatting in Power BI! Initially, this feature had its flaws, but recent improvements make it a must-try tool for efficient report design. In this video, you’ll learn how to activate On Object Formatting and see why it’s superior to the traditional methods. From intuitive double-click formatting to the ability to seamlessly swap fields without losing formatting, the feature enhances productivity while keeping the familiar side panel intact for users transitioning from older workflows.
The tutorial also highlights useful settings like disabling the default auto-arrange feature, which can complicate visual adjustments, and shares practical tips for navigating occasional glitches. D.
Let’s get this tool even better by sharing feedback with Microsoft!
The team and I at Access Analytic develop Power BI and Excel solutions for clients in Australia and deliver training around the World. https://accessanalytic.com.au/
Did you know I've written a book "Power BI for the Excel Analyst"?
https://pbi.guide/book/
Connect with me
wyn.bio.link
Discover why it’s time to embrace On Object Formatting in Power BI! Initially, this feature had its flaws, but recent improvements make it a must-try tool for efficient report design. In this video, you’ll learn how to activate On Object Formatting and see why it’s superior to the traditional methods. From intuitive double-click formatting to the ability to seamlessly swap fields without losing formatting, the feature enhances productivity while keeping the familiar side panel intact for users transitioning from older workflows.
The tutorial also highlights useful settings like disabling the default auto-arrange feature, which can complicate visual adjustments, and shares practical tips for navigating occasional glitches. D.
Let’s get this tool even better by sharing feedback with Microsoft!
The team and I at Access Analytic develop Power BI and Excel solutions for clients in Australia and deliver training around the World. https://accessanalytic.com.au/
Did you know I've written a book "Power BI for the Excel Analyst"?
https://pbi.guide/book/
Connect with me
wyn.bio.link



;-??_)
🫶🏻 Join the channel to get access to perks:
https://www.youtube.com/channel/UCvD2rJJrp0aS48-KCk0eMHQ/join
🧑🏻🎓Learning Power BI?
Check out our online course
https://accessanalytic.thinkific.com/
📗 Did you know Ive written a book Power BI for the Excel Analyst?
https://pbi.guide/book/
The team and I at Access Analytic develop Power BI and Excel solutions for clients in Australia and deliver training around the World.
🌐 https://accessanalytic.com.au/
00:00 Introduction
01:10 Create your Excel startup folder
01:33 Customize cell styles like Center Across
02:13 Modify number format with comma style
02:50 Create custom table and slicer styles
03:55 Save your setup as Book.xltx
04:40 Enable auto-loading with Excel startup path
05:56 Use Quick Access Toolbar for custom launch
06:27 Set default pivot table options Excel Gem: Set your default start up file](https://i.ytimg.com/vi/PlitF5GgQ2o/mqdefault.jpg)






