DAX and UDF SVG Charts in Power BI: Complete Guide
Learn to build DAX and UDF SVG charts in Power BI with this complete guide. Create custom visualizations using pure DAX code with dynamic scaling and conditional formatting.
Oscar Martínez
Data, BI and AI | Operational Lead | Power BI & Azure Expert | Governance-Driven Strategy | Product Owner
I'm a Data, BI, AI and Finance professional with 15+ years of experience bridging the worlds of finance, technology, and analytics. Today, I serve as the Operational Lead for Data Platform Services in Switzerland, driving secure, scalable, and governance-aligned data solutions.
Role: Founder, Developer & Writer
Can explain Power BI DAX formulas while making perfect Swiss coffee ☕
Power BI UX Design Data Visualization Business Intelligence User Research
Articles by Oscar Martínez (26)
DAX + UDF = the React of Power BI
Learn how to combine Power BI DAX user-defined functions with HTML visuals to build reusable KPI cards, tables, and progress bars that wow report stakeholders.
Automating Power BI Themes with Fabric, Notebooks and BIBB Theme Generator API: A Complete Guide
Learn how to automate Power BI report theme updates using Microsoft Fabric, Python, and the BIBB Theme Generator API for seamless theme management.
What is a Template in Power BI? Settling the debate.
Understand what each Power BI Template type does, when to use it, and how it shapes the user experience.
Data Exfiltration in Power Query - Understanding the Risk and Protections
Data Exfiltration in Power Query: Understanding the Risk and Protections
Automation of the 'Meet the Team' PDF Slides with Power BI
Automate 'Meet the Team' PDF slides using Power BI, SharePoint, and Power Automate to save time, ensure consistency, and scale across proposals.
Power BI AI CV Analysis for Recruitment: Automating Candidate Matching with OpenAI
Discover how Power BI and OpenAI work together for AI-driven CV analysis in recruitment, enabling efficient candidate matching and insights for data-driven hiring.
Review of The Data Storyteller's Handbook: How to Create Business Impact Using Data Storytelling by Kat Greenbrook
An in-depth review of Kat Greenbrook's comprehensive guide to data storytelling for business impact, covering foundational knowledge and advanced techniques for BI professionals.
Modern Design in Business Intelligence: Glassmorphism in Power BI
Learn how to implement glassmorphism design techniques in Power BI reports using transparency, blur effects, and modern UI principles for enhanced visual appeal.
Enhancing BI with AI-Driven Data Analysis and ChatGPT Power Query Integration
Discover how AI-driven data analysis through ChatGPT and Power Query integration can revolutionize your Business Intelligence workflows and data preprocessing capabilities.
Web.Contents and APIs in Power BI
Learn how to consume APIs in Power BI using Web.Contents function with practical examples including Chuck Norris API, authentication methods, and real-world implementations.
PnP PowerShell for SharePoint for Power BI Users
Learn how to use PnP PowerShell to manage SharePoint data sources for Power BI projects, including creating test lists, adding fields, and automating data management tasks.
Power BI JSON Report Theme Generator by BIBB
Discover BIBB's free Power BI Theme Generator that simplifies theme creation with live previews, multiple customization methods, and one-click JSON export.
ServiceNow data in Power BI
Learn two ways to connect Power BI to ServiceNow data: using the API with Web.Contents() and the AlphaServe connector for seamless integration.
Replicating a Harvard Business Review (HBR) Infographic with Power BI, Deneb, and HTML
Learn how to recreate complex HBR infographics in Power BI using Deneb visualizations and HTML visuals. A step-by-step guide to replicating quantum computing industry data visualizations.
Everything’s OK Alarm
What Homer Simpson’s ‘Everything’s OK’ alarm teaches us about analytics, KPIs, and business dashboards. Learn why tracking the right metrics matters more than tracking everything.
Having a Light and Dark Version of Your Power BI Reports
Discover three effective approaches to create light and dark versions of your Power BI reports, from JSON themes to DAX methods and duplicate items, with pros and cons for each.
Securing Your API-Power BI Data with Azure Key Vault
Learn how to secure API secrets in Power BI developments using Azure Key Vault. A comprehensive guide with step-by-step instructions for implementing secure API coding practices.
The Power of BI User Personas
Learn how to create and implement Business Intelligence user personas to design more effective Power BI dashboards and analytics solutions focused on user needs.
Wireframing in Power BI
Learn how to create effective wireframes for Power BI dashboards and reports using various tools and proven methodologies to improve design workflow and stakeholder collaboration.
SharePoint API use in Power BI
Learn how to use SharePoint's API to efficiently load data in Power BI, improving performance and providing better control over your data connections.
How to Use SharePoint OData in Power Query
Learn best practices for using SharePoint OData in Power Query to streamline data imports and overcome common challenges with large datasets.
Using HTML Buttons in Power BI - Step-by-Step Guide
Learn how to enhance your Power BI reports with custom HTML buttons for improved interactivity and design. Complete guide with code samples and implementation steps.
Azure DevOps in Power BI: Optimizing Data Extraction
Learn how to integrate Azure DevOps data into Power BI using OData and REST API methods to overcome the limitations of native connectors and access comprehensive reporting data.
Power Query Text Cleaning Function
Streamline text manipulation in Power Query with a versatile custom function that handles character replacement, word swapping, and comprehensive text cleaning operations.
Dashboard Design UX Basics - Whitespace and Alignment
Learn how to optimize your BI dashboard design using whitespace and alignment principles. Discover key UX strategies that transform data displays into compelling visual stories.