All Blog Posts

D

Oscar Martínez

October 26, 2025

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.

D

Oscar Martínez

September 26, 2025

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.

F

Oscar Martínez

September 20, 2025

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.

P

Oscar Martínez

June 27, 2025

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.

U

Francesco Marino

May 23, 2025

Improving BI User Experience in Corporate Environments: Practical Strategies That Work

Discover actionable techniques for improving BI user experience in corporate environments, focusing on user personas, training, and documentation.

P

Oscar Martínez

April 21, 2025

Data Exfiltration in Power Query - Understanding the Risk and Protections

Data Exfiltration in Power Query: Understanding the Risk and Protections

P

Oscar Martínez

March 28, 2025

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.

P

Hamza Boubou

March 13, 2025

Master Power BI Time Comparisons and Top N Analysis for Optimal Performance

Learn how to perform Power BI Time Comparisons and Top N Analysis with optimal performance using calculation groups and field parameters instead of slow RANKX functions.

U

Bushra Amjad

January 25, 2025

Learn How Startups Can Harness Power BI and User-Centred Design for Impactful Dashboards

Discover how Startups Power BI User-Centred Design transforms raw data into actionable insights, improving decision-making and business success.

P

Ilfat Galiev

December 18, 2024

Charticulator Visual Community: A New Chapter in Custom Visual Design

Discover the evolution of Charticulator from its origins to the new community-driven version, featuring enhanced capabilities, dataset editor, public charts, and improved visualization tools for Power BI.

P

Oscar Martínez

November 14, 2024

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.

U

Oscar Martínez

August 7, 2024

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.

U

Oscar Martínez

June 9, 2024

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.

U

Sajjad Ahmadi

May 21, 2024

Dynamic Heatmap Selection: Enhancing Dashboard Interaction and User Experience

Learn how to create interactive heatmaps in Power BI that respond to user selections, improving dashboard functionality and user engagement through dynamic conditional formatting.

U

Olga Rudakova

May 3, 2024

Effective Dashboard Design: Essential Layout Strategies for Clear, Actionable BI Dashboards

Explore key strategies for effective dashboard design, ensuring data is visible and actionable. Learn Z-pattern layouts, fast vs slow dashboards, and proven design principles.

U

Gregor Brunner

April 5, 2024

Optimizing User Experience: Cleaning and Improving Power BI Reports and Models

Learn how to optimize Power BI semantic models using Measure Killer to improve performance, enhance user experience, and streamline development workflows.

A

Oscar Martínez

March 16, 2024

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.

A

Sara Rodriguez

March 12, 2024

Harnessing AI-Driven Data Storytelling to Connect and Inspire

Learn how AI-driven data storytelling can help you understand your audience better and create more engaging business intelligence experiences that resonate emotionally and drive action.

U

Diana Maier

January 23, 2024

Elevating BIBB to UX Driven Mastery

A journey through BIBB's transformation from 'Design Driven' to 'UX Driven' BI, exploring our identity evolution, product development, and new visual design principles that enhance user experience.

M

Oscar Martínez

September 23, 2023

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.

U

Diana Maier

August 29, 2023

Unveiling the Atomic Artistry: Crafting Seamless Data Table Experiences for Users

Learn how to design exceptional data tables using atomic design principles, understanding user behavior patterns, and implementing best practices for optimal user experience.

D

Oscar Martínez

August 27, 2023

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.

P

Oscar Martínez

August 12, 2023

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.

P

Oscar Martínez

July 3, 2023

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.

P

Oscar Martínez

May 7, 2023

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.

P

Diana Maier

April 25, 2023

Cracking the Color Code: How to Design Better Power BI Dashboards

Step into the world of Power BI dashboards, where data visualization meets the art and science of color. Learn about color harmonies, neutral colors, contrast, and minimal color usage to create impactful dashboards.

P

Oscar Martínez

February 1, 2023

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.

U

Oscar Martínez

January 29, 2023

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.

P

Oscar Martínez

January 14, 2023

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.

U

Oscar Martínez

January 10, 2023

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.

U

Oscar Martínez

December 28, 2022

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.

M

Oscar Martínez

December 27, 2022

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.

U

Raziel Colosia

October 12, 2022

Dashboard/Report design from scratch: Grid system, Information design, and Wireframe. Part 2

Learn information design principles for dashboard creation, including organizing information, visual hierarchy, and the inverted pyramid structure for effective data storytelling.

U

Raziel Colosia

September 26, 2022

Dashboard/Report design from scratch: Grid System, Information Design, and Wireframes - part 1

Learn how to apply grid systems to dashboard design using modular grids in Power BI. Discover how to create structured, organized layouts for better report design.

U

Raziel Colosia

May 11, 2022

Grid System Applied to Report Design in Power BI

Learn how to apply grid system principles to create well-organized and visually appealing Power BI reports using proper alignment, spacing, and layout techniques.

U

Raziel Colosia

April 22, 2022

Build a Navbar using buttons in Power BI

Learn how to create a professional navigation bar in Power BI using blank buttons, with design considerations, button states, and implementation steps.

U

Raziel Colosia

April 4, 2022

UX/UI applied to my Power BI report - Part 1: Navigation

Learn essential UX/UI principles for better Power BI report navigation, including Jakob's Law and how to create user-friendly navigation experiences.

M

Oscar Martínez

March 27, 2022

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.

P

Oscar Martínez

March 24, 2022

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.

P

Oscar Martínez

March 15, 2022

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.

M

Oscar Martínez

March 13, 2022

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.

U

Oscar Martínez

February 20, 2022

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.