Press "Enter" to skip to content

Category: Visualization

Using Field Parameters in Power BI for Dynamic Views

Annamarie Van Wyk demonstrates how to use field parameters to slice data in Power BI:

If you’ve ever built a Power BI report and found yourself duplicating charts for daily, weekly, monthly, or yearly views — you’re not alone. It’s one of the most common (and frustrating) dashboard challenges: “Can we see this by day? Actually, make it by week. No wait — what about monthly?”

Instead of building five versions of the same visual, you can do it all with one — thanks to Field Parameters.

Read on to see how it all works.

Leave a Comment

Adding a Drillthrough Button in Power BI

Elena Drakulevska adds a button:

If you’ve been building Power BI reports, you probably know about drillthrough.

In short: drillthrough lets users move from a summary view to a detail page focused on one data point. For example, you can right-click on Austria in a sales chart and jump straight to a page showing visuals and metrics only about Austria.

Sounds powerful, right?

The catch: most users don’t even know it’s been implemented.

The other catch: those of us sad souls using Power BI Report Server don’t get drillthrough at all.

Leave a Comment

Conditional Formatting for Clarity in Power BI

Ben Richardson tells a story:

Consider a typical sales dashboard filled with charts, KPIs, and large tables.

Users often have to guess what is important, read legends, or ask questions like “What does this mean?” or “Which numbers require attention?”

Many dashboards display data but do not guide users to key insights effectively.

Read on for a few different possibilities based around conditional formatting.

Leave a Comment

Organizational Themes in Power BI

Boniface Muchendu takes a peek at a fairly new feature:

Keeping your Power BI reports consistent, clean, and on-brand just got a lot easier. With the new Organizational Themes feature released in June 2025, Power BI now allows organizations to centrally manage and distribute custom report themes across all users. No more manual theme imports or scattered design standards.

Read on to see how it works, and hopefully your organization does not have terrible standards.

Leave a Comment

Using Sankey Diagrams in Power BI

Ben Richardson creates a visual:

Ever wished you could see exactly how customers move through your sales funnel, or how costs flow across your business?

A Sankey Diagram makes those flows visible, showing not just totals but how values split and connect between categories.

In Power BI, the Sankey Diagram is available as a custom visual from AppSource, designed to reveal relationships and flow patterns.

There are specific times and places for Sankey charts. It requires having a natural flow in your data—that is, you need different states of data, those states should typically only “move” in one direction, you have paths to get from one state to another, and there is enough variety in pathing that not all of the data is going to the same location. The more of these rules you violate, the less useful a Sankey diagram is.

Comments closed

Adding Carousel Buttons in Power BI

Ben Richardson builds a carousel:

If you’ve ever tried to cram too many charts onto one report page, you know what happens.

The page gets cluttered, users don’t know where to look, and the story you’re trying to tell gets lost.

Carousel buttons fix that problem.

Instead of stacking visuals side by side:

You place them in the same spot and let people flip through them like slides.

It feels cleaner, takes up less space, and keeps the audience focused.

Click through to see how it works. Note that carousels can be quite useful, but they also go against one of the tenets of dashboard design: glanceability. If I need to click, drag, scroll, or otherwise manipulate the dashboard before I can see the information I need to act, it’s not glanceable—I cannot gather relevant information at a glance and act upon it.

In other words, if I’m giving somebody an interactive Power BI report with the intent that the person will dig into results, then a carousel can be quite reasonable. But if I’m creating a dashboard that should be up most of the time and available for people to see, carousels aren’t a great call.

Comments closed

Enabling Map Visuals in Power BI

Boniface Muchendu gets past the X:

Have you ever tried to create a map in Power BI only to see an error instead of your visualization? If your Power BI maps are not working, you’re not alone. By default, some map and filled map visuals may be disabled due to security settings. The good news? With a few quick adjustments, you can enable maps in Power BI Desktop or, if needed, in your organization’s tenant settings.

Read on to see why this visual might be disabled and how to enable it.

Comments closed

Time Series Forecasting in Python

Myles Mitchell builds an ARIMA model:

In time series analysis we are interested in sequential data made up of a series of observations taken at regular intervals. Examples include:

  • Weekly hospital occupancy
  • Monthly sales figures
  • Annual global temperature

In many cases we want to use the observations up to the present day to predict (or forecast) the next N time points. For example, a hospital could reduce running costs if an appropriate number of beds are provisioned.

Read on for a primer on the topic, a quick explanation of ARIMA, and a sample implementation using several Python packages.

Comments closed

Visualizing ML Model Outcomes with Matplotlib

Matthew Mayo shares a few tips:

Visualizing model performance is an essential piece of the machine learning workflow puzzle. While many practitioners can create basic plots, elevating these from simple charts to insightful, elevated visualizations that can help easily tell the story of your machine leanring model’s interpretations and predictions is a skill that sets great professionals apart. The Matplotlib library, the foundational plotting tool in the scientific and computational Python ecosystem, is packed with features that can help you achieve this.

This tutorial provides 7 practical Matplotlib tricks that will help you better understand, evaluate, and present your machine learning models. We’ll move beyond the default settings to create visualizations that are not only aesthetically pleasing but also rich in information. These techniques are designed to integrate smoothly into your workflow with libraries like NumPy and Scikit-learn.

Click through for those tips.

Comments closed

Storytelling with Time Series Scatter Charts in Power BI

Reza Rad takes us through data changes:

Column or Bar chart can be easily used for showing a single measure’s insight across a category. Mixed charts such as Line and Column chart can be used for showing two measure and comparing their values across a set of categories. However there are some charts that can be used to show values of three measures, such as Scatter Chart. Scatter chart not only shows values of three measure across different categories, it also has a special Play axis that helps you to tell the story behind the data. In this post you’ll learn how easy is to visualize something with Scatter chart and tell a story with that. If you like to learn more about Power BI, read Power BI online book; from Rookie to Rock Star.

Read on for the blog post as well as a video version.

Comments closed