M365 Show - Modern work, security, and productivity with Microsoft 365
Mirko Peters (Microsoft 365 consultant and trainer)
416 episodes
7 hours ago
Welcome to the M365 Show — your essential podcast for everything Microsoft 365, Azure, and beyond. Join us as we explore the latest developments across Power BI, Power Platform, Microsoft Teams, Viva, Fabric, Purview, Security, and the entire Microsoft ecosystem. Each episode delivers expert insights, real-world use cases, best practices, and interviews with industry leaders to help you stay ahead in the fast-moving world of cloud, collaboration, and data innovation. Whether you're an IT professional, business leader, developer, or data enthusiast, the M365 Show brings the knowledge, trends, and strategies you need to thrive in the modern digital workplace. Tune in, level up, and make the most of everything Microsoft has to offer.
All content for M365 Show - Modern work, security, and productivity with Microsoft 365 is the property of Mirko Peters (Microsoft 365 consultant and trainer) and is served directly from their servers
with no modification, redirects, or rehosting. The podcast is not affiliated with or endorsed by Podjoint in any way.
Welcome to the M365 Show — your essential podcast for everything Microsoft 365, Azure, and beyond. Join us as we explore the latest developments across Power BI, Power Platform, Microsoft Teams, Viva, Fabric, Purview, Security, and the entire Microsoft ecosystem. Each episode delivers expert insights, real-world use cases, best practices, and interviews with industry leaders to help you stay ahead in the fast-moving world of cloud, collaboration, and data innovation. Whether you're an IT professional, business leader, developer, or data enthusiast, the M365 Show brings the knowledge, trends, and strategies you need to thrive in the modern digital workplace. Tune in, level up, and make the most of everything Microsoft has to offer.
M365 Show - Modern work, security, and productivity with Microsoft 365
27 minutes
1 week ago
STOP Using Power BI Themes That Lie
(00:00:00) The Power of Theme in Power BI
(00:00:00) The Hidden Dangers of Color Themes
(00:00:18) The Five Invisible Failures
(00:00:37) Contrast: The First Line of Defense
(00:01:11) The Four Laws of Contrast
(00:01:59) Redundancy: The Secret to Visibility
(00:02:23) The Containment Procedure for Alerts
(00:04:57) The Matrix Matrix: Subtotals in Disguise
(00:06:17) The Subtotal Containment Protocol
(00:09:40) Tooltips: The Hover Hazard
Most creators treat Power BI themes as “brand colors,” but those hues can bury alerts, erase subtotals, distort slicer states, and hide KPIs in plain sight. This episode exposes five invisible theme failures and delivers a ruthless, pass/fail validation protocol to guarantee clarity, accuracy, and accessibility across any report. 1. The Accessibility Reactor — Contrast for Alerts Is Failing Your alerts aren’t “subtle”—they’re disappearing. Low contrast turns KPIs into decorative noise. Key Problems
Alert colors fall below AA accessibility thresholds
Background layers, images, and card tints distort perceived contrast
Color-only alerts fail under glare, projection, or color vision deficiency
Validate exact pixel contrast using Color Contrast Analyzer or WebAIM
Add redundancy: icons + labels + color
Enforce no text under 4.5:1, ever
Strengthen line/grid contrast so visuals remain readable in motion
Result Instantly recognizable alerts, reduced cognitive load, and faster decision-making. 2. Matrix Subtotal Leak — Aggregates Are Camouflaged Subtotals and grand totals often look identical to detail rows, causing executives to miss critical rollups. Symptoms
Equal weight and color between detail rows and subtotals
Zebra striping or drill indents misleading the eye
Totals disappearing at 80% zoom
Fixes
Explicitly style subtotal + total selectors in theme JSON
Add background bands, stronger text weight, and a divider line
Ensure totals meet 3:1 contrast (4.5:1 for grand totals)
Right-align numbers, reduce noise, and clarify units
Pass/Fail Protocol
Subtotals identifiable in <1 second at 80% zoom
Divider visibly separates detail vs. aggregate
No conditional formatting overriding subtotal visibility
3. Tooltip Chaos Plasma — Hover Context Lost Translucent tooltips, low-contrast text, and inconsistent styles create confusion at the exact moment users seek clarity. Common Failures
Header and value tones too faint
Pane transparency letting chart noise bleed through
Report page tooltips violating contrast rules
Tooltip DAX slowing the interaction
Fixes
Set tooltip title/value/background styles in theme JSON
Enforce 4.5:1 contrast on all tooltip text
Use opaque backgrounds with visible shadows
Keep tooltip content minimal and high-signal
Optimize queries for sub-150ms rendering
Pass/Fail
Legible over dense visuals
Title/value hierarchy obvious in <0.5s
No KPI name truncation
No background noise leaking through
4. Card Visual Uranium — Hierarchy Out of Control Card visuals carry enormous perceptual weight. Without governance, they become mismatched, chaotic, and misleading. Common Issues
Inconsistent font sizes across pages
Labels and values using identical weight
Poor contrast or ghost-gray labels
Truncated numbers and wrapping text
KPIs relying solely on color to indicate state
Fixes
M365 Show - Modern work, security, and productivity with Microsoft 365
Welcome to the M365 Show — your essential podcast for everything Microsoft 365, Azure, and beyond. Join us as we explore the latest developments across Power BI, Power Platform, Microsoft Teams, Viva, Fabric, Purview, Security, and the entire Microsoft ecosystem. Each episode delivers expert insights, real-world use cases, best practices, and interviews with industry leaders to help you stay ahead in the fast-moving world of cloud, collaboration, and data innovation. Whether you're an IT professional, business leader, developer, or data enthusiast, the M365 Show brings the knowledge, trends, and strategies you need to thrive in the modern digital workplace. Tune in, level up, and make the most of everything Microsoft has to offer.
