Press "Enter" to skip to content

Category: Visualization

Bars vs Lines in Visuals

Cole Nussbaumer Knaflic contrasts a pair of visual options:

Bringing clarity to your data storytelling doesn’t usually mean you need to learn and use more chart types. It does mean choosing visuals that are appropriate for your data and what you’re trying to communicate. Two of the most useful tools in our graphing toolkit—bar charts and line graphs—often do the heavy lifting. Knowing when to use which (and when to switch) can make all the difference.

This lesson came up recently as I revisited our new book, storytelling with data: before & after. I’ll share two scenarios where the choice between bars and lines matters. They are both from Chapter 2, which is titled “embrace basic graphs.”

Read on for an initial chart that is using the wrong type of visual, and then how we can tell different stories using the same data based on our choice of visual.

Leave a Comment

Using Dygraphs in R

Thomas Williams builds a chart:

I also wanted to get a little interactive with my analysis, and came across Dygraphs for R https://rstudio.github.io/dygraphs/ which wraps the “venerable” (according to creator Dan Vanderkam https://github.com/danvk) javascript charting library of the same name, first released in 2006.

I used Dygraphs in an R script file (it can work equally well in R Markdown) to quickly chart my time series data, loaded from the CSV file. Dygraphs were simple to use, are a solid pick among other charting libraries and very functional for being free and open source.

Read on for a few examples of charts, as well as the entirety of Thomas’s code.

Leave a Comment

Toggling Light and Dark Modes in Power BI

Elena Drakulevska builds a switch:

We learned in the last post that while dark UI feels sleek, it’s not automatically accessible and it shouldn’t be your default strategy (hello, contrast + glare). In most cases, light mode is the more accessible baseline (just imagine trying to work on a sunny beach or on your balcony with dark mode… nightmare).

But UX is also about choice. Some users love light, some swear by dark. So let’s give them control.

Read on to see how, without sacrificing much accessibility.

Leave a Comment

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.

Comments closed

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.

Comments closed

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.

Comments closed

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.

Comments closed

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