# Visualization Ideas To Show Client Growth Through Time

I want to show you a cool technique, bringing together DAX measures and some visualization ideas. You may watch the full video of this tutorial at the bottom of this blog.

In this tutorial, I’ll show you how to highlight the trajectory of a client performance through time. I’ll visualize it in a way that you can easily see how a client or customer moved from one group to another through time.

I’m going to do this by creating a ranking calculation. We have some numbers and list of clients here, but when we can’t tell whether these clients are our top clients or our bottom ones – it’s not easy to see that visually.

## DAX Measures To Rank Customers

So, I’m going to create a new measure that is going to rank our customers each year. It’s a simple ranking formula and I’ll just call it Customer Ranking. I’ll use RANKX, then go ALL Customers, and then go Total Revenue, and lastly, I’ll place descending (DESC).

So now you can see in the visualization below that some customers ranked highly all the time, but Roger Griffin ranked high one year but low another year, and then ranked a little bit high in another.

For this type of analysis, it would be great to know how many customers we actually have, right? So I’ll create another measure for Total Customers. I’ll use the function called COUNTROWS for our Customer Table

I’ll put this in a card visualization, and we can see that we have more than 3,000 customers.

## Visualization Ideas Using Conditional Formatting

We can say, 1,000 is one group or 1,000 to 2,000 as a group, and then 2,000 and above as another group. But I want to show it in the visualization. I don’t want to have the ranking formula here.

So, I’m going to go to the Conditional Formatting and then to the Background Color.

I’m going to format by Rules. I’ll select my Customer Ranking measure (for the Based on fields) and then input the rules. If the value is greater than zero and less than 1,000, I want the background to be the lighter purple color. If it’s greater than 1,000 and less than or equal to 2,000, then I’m going to use the darker shade of purple. If it’s greater than 2,000 number and less than or equal to say 20,000, then it will be the darkest purple color.

These rules are being determined by the Customer Ranking formula. Then, I click OK. And now, with a little bit of additional labelling, we can see, through time, how these customers have jumped or performed.

Remember that the lighter shade was our top-ranking customers. That ranking is nowhere in this visualization, but we can see our top-ranking customer; then it looks like they dropped in their rank the following year.

## Conclusion

These are great visualization ideas to showcase or highlight how a customer is travelling through time.

You can use different techniques here to showcase them in your own way. Here, I’m using years. You can use any number or timeframe. You can adjust the colors and also the rules as you like to match your report.

You can also add this tooltip for additional information. If you want to create something like this, check out my video tutorial about placing dynamic map visualizations in a tooltip.

I hope that this tutorial gives you some unique visualization ideas to showcase your report analysis in an interesting and more compelling way.

All the best!

Sam

Sam McKay, CFA
Sam is Enterprise DNA's CEO & Founder. He helps individuals and organizations develop data driven cultures and create enterprise value by delivering business intelligence training and education.

## Power BI Report Example For An Optical Dataset

A lot of you may know that we have an ongoing Power BI Challenge. One of our recent Power BI report...

## AVERAGEX: Calculating Average Per Day In Power BI

Here I'm going to show you how to use the function AVERAGEX with DAX in Power BI. You may watch the...

## Power BI Default Slicer Value Explained

One of the key features of Power BI is the slicer, which allows you to filter your data based on...

## Format Data In Power BI: Addressing Irregular Data Formats

In today's blog post, we'll discuss Problem of the Week #6. I'll show you how to format data in Power...

## Calculating A Rolling Average In Power BI Using DAX

In this tutorial, I’m going to show you how to calculate a dynamic Rolling Average in Power BI using...

## Paginated Report In Power BI: An Introduction

In this tutorial, you’ll learn about paginated reports in Power BI. A paginated report is another name...

## Creating Measure Tables & Subfolders In Power BI

For today's blog, I'll cover measure tables and subfolders. We're going to set up measure tables, and...

## Ultimate Guide To Multiple IF Statements In Power BI

If you are looking to create more complex logic, then using multiple if statements in Power BI is a...

## Highlight Highest & Lowest Values Using Quick Measure In Power BI

Quick Measures Pro is a powerful external tool to streamline data analysis and visualization in Power...

## Power BI Desktop Update: The Charticulator Visual

Today, I would like to go over something that I found out by scrolling through Twitter. What I have...

## How To Build a Portfolio And Showcase Your Data Projects to Employers

In today’s data-driven world, the ability to work with data has become an essential skill. Whether...

## New vs Existing Customers – Advanced Analytics In Power BI

If you’re an online retailer or a high frequency sales operation, then understanding your customer...