Visualization Technique – Power BI Column Charts & Filters

In this blog, I’ll show you a really easy and unique visualization technique that you can do in Power BI. Here I use stacked column charts and dynamic filters to make this work seamlessly. You may watch the full video of this tutorial at the bottom of this blog.

This example came from a Power BI challenge that we held at Enterprise DNA, and this was one of my submissions. The challenge was around an HR consultation process, and the visualization technique enables me to show a change from one state to another.

visualization technique

What I mean by “one state to another state” is that there were two interviews per consultation (when I say state, I mean, regions). So, one state was the first interview, and another state was the second interview. I wanted to create a visualization that would showcase the change in how people felt about the consultation for each state.

This visualization technique is significant because it could be used in many different scenarios. It took a bit of out-of-the-box thinking around visualizations to actually showcase data like this in a more compelling way.

Showing Change In One State To Another State

What I’m talking about here is the top layer of the report. Here, we have working hours, pay policy, health, safety, and performance. We have the first and second interviews, and the numbers under them represent the feelings (unhappy, neutral, happy) of the people during the interview, respectively.

The report is also dynamic. If I select a particular interviewer, for example, the page will update accordingly. Moreover, we also have some granular details about each individual down below.

visualization technique

I’ve used a couple of features. I placed stacked column charts next to each other. Then, I made a simple calculation using DISTINCTCOUNT to count the number of employees.

visualization technique

Then, I filtered it by outcome (first, second), and this filter created the legend.

visualization technique

I haven’t done any fancy formulas here. I just used column charts and the filter function, and I turned off almost everything around the visualization.

Visualization Technique: Grouping & Aligning Visuals

I created the column charts individually and aligned both visualizations together. I grouped them together, so I can multi-select things.

To do this, I go to Format, then click on Group. Once I do that, I can move the visualizations around together. I just “copy and paste” them to create the rest of the interview categories (pay policy, health, etc.). Then, I change the filters on each different interview.

visualization technique

Visualization Technique: Dynamic Filtering

This report is dynamic because of the filtering that I placed in the filtering area. So, when I select a particular item in any of the visualizations here, the rest of the page updates the results that it will show.

For instance, if I select one of the consultations, Health, you can see that it’s now only showing the results for Health.

I can place another filter here as well, and so we can get really granular on the results. We have below the results for the Health consultation with Jesse as the first interviewer and Carol as the second interviewer.

***** Related Links *****
Using Filter Fields & Visual Interactions To Create Compelling Visualizations In Power BI
How To Use The Built-in Analytics For Power BI Scatter Charts
Power BI Shape Map Visualization For Spatial Analysis

Conclusion

This is my way of being creative and thinking outside the box with the visualizations in my Power BI reports and showcase insights in a compelling and unique way.

It takes a bit of imagination to create something like this. I hope that I’ve inspired you to implement this visualization technique in your own reports and not just rely on the visualization palette.

There are far more options out there for you in terms of what you can achieve visually, and that’s what’s going to engage your consumers more.

If you want to have a play around with this particular report, check out the Enterprise DNA Showcase page.

All the best!

Sam

Enterprise DNA Power BI On-Demand

The Latest

As you continue your journey as a Python programmer, you’ll want to write code that is more efficient, readable, and…

Python Inline If: Simplify Your Conditional Expressions

You’ve been cruising through your Python journey, slicing through lists, taming those wild tuples, and maybe even wrestling with a…

Python Empty String: Understanding and Handling It Effectively

Power BI financial dashboards provide a quick and easy way to monitor an organization’s financial performance in real-time. By consolidating…

Power BI Financial Dashboard Examples: Key Insights for Businesses

When working with integers in Python, you should know the maximum value your code can handle. This will depend on…

Python Max Int: Understanding Maximum Integer Limits

Pi is a fundamental mathematical constant that represents the ratio of a circle’s circumference to its diameter. Leveraging Pi in…

4 Ways to Use Pi in Python With Examples

ChatGPT is an advanced AI-powered tool that can transform the way you write code. Developed by OpenAI, ChatGPT accelerates your…

ChatGPT for Coding: A Guide With Practical Examples

When working with data projects in Python, you are most likely to use datetime functions. Almost every dataset that you’ll…

Python datetime, a comprehensive guide with examples

Power BI is a powerful business analytics tool that helps you visualize and analyze data from various sources. One of…

Power BI Themes: How to Customize Your Reports with Ease

With the advent of ChatGPT, individuals and businesses worldwide have been using it to simplify their daily tasks and boost…

ChatGPT for Data Scientists: Unleashing AI-driven Insights

Staying ahead of the curve in data analysis is essential to your success in business. One of the most innovative…

ChatGPT for Data Analysts: Revolutionizing Insights and Reporting

Imagine being able to look at your data from every which way — from the bird’s eye view right down…

Power BI Hierarchy: Unlocking Levels and Drill-Downs in Visualizations

As you explore Python and take on more complex projects, you’ll notice that some projects have lots of files. Managing…

os.path.join: Simplifying File Path Operations in Python

Load More