Uploaded July 2025 | Updated November 2026, 10 hours ago
🧑🏻🎓Learning Power BI?
Check out our online course
accessanalytic.thinkific.com
or pbi.guru/training
Want to let your Power BI users choose how numbers are displayed — thousands, millions, or billions — with dynamic decimal formatting? This video breaks it down step-by-step. Learn how to set up a disconnected helper table in Power BI, create formatting codes that adapt to your user’s slicer selections, and apply a dynamic measure that responds seamlessly. Whether it's showing 2.1M or 1.42B, the video demonstrates how to maintain professional formatting control with ease.
From formatting positive and negative values to default settings when no slicer is selected, this tutorial covers everything. You’ll see how dynamic format strings work in Power BI measures, explore slicer-driven views across multiple report pages, and avoid common traps like misapplied relationships or formatting loss. Perfect for anyone who builds reports for varied audiences or just wants to add a polished touch to their dashboards.
Units Format
Base #,0;(#,0);-
Thousands 0 dp #,0,. "K";(#,0,.) "K";-
Millions 1 dp #,0,,.0 "M";(#,0,,.0) "M";-
Billions 2 dp #,0,,,.00 "B";(#,0,,,.00) "B";-
🫶🏻 Join the channel to get access to perks:
youtube.com/channel/UCvD2rJJrp0aS48-KCk0eMHQ/join
📗 Did you know I've 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/
🧑🏻🎓Learning Power BI?
Check out our online course
accessanalytic.thinkific.com
or pbi.guru/training
Want to let your Power BI users choose how numbers are displayed — thousands, millions, or billions — with dynamic decimal formatting? This video breaks it down step-by-step. Learn how to set up a disconnected helper table in Power BI, create formatting codes that adapt to your user’s slicer selections, and apply a dynamic measure that responds seamlessly. Whether it's showing 2.1M or 1.42B, the video demonstrates how to maintain professional formatting control with ease.
From formatting positive and negative values to default settings when no slicer is selected, this tutorial covers everything. You’ll see how dynamic format strings work in Power BI measures, explore slicer-driven views across multiple report pages, and avoid common traps like misapplied relationships or formatting loss. Perfect for anyone who builds reports for varied audiences or just wants to add a polished touch to their dashboards.
Units Format
Base #,0;(#,0);-
Thousands 0 dp #,0,. "K";(#,0,.) "K";-
Millions 1 dp #,0,,.0 "M";(#,0,,.0) "M";-
Billions 2 dp #,0,,,.00 "B";(#,0,,,.00) "B";-
🫶🏻 Join the channel to get access to perks:
youtube.com/channel/UCvD2rJJrp0aS48-KCk0eMHQ/join
📗 Did you know I've 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/










