# 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.

## Find Out How To Quickly Create Virtual Groups In Power BI

Did you know there is a way to create groups virtually in Power BI? You may watch the full video of...

## DateTime Value: How To Strip Off Seconds

In todayâ€™s blog, we will examine three ways to strip off seconds from a DateTime value. You can...

## Course Completion Certificates Now Available At Enterprise DNA Online

TheÂ Enterprise DNA Team has been working hard to deliver a brand-new certificate offering for those...

## Selenium IDE In Power Automate UI Flows

In this tutorial, we'll discuss the Selenium IDE option in Power Automate UI flows. When creating UI...

## Using The DAX Studio User Interface: An Overview

In this tutorial, weâ€™ll go through a quick overview of all the options available in the user interface...

## See Changing Results Using Calculated Columns In Power BI

In this tutorial, I'm going to run through a number of great analytical techniques that you can combine...

## InfoPath: Explained With Examples

Are you tired of drowning in a sea of paperwork and struggling to keep your data organized? Enter...

## Retail Management & Demand Forecasting Reports In Power BI

In this Power BI Showcase, we focus on reports that provide analysis on retail management,...

## First N Business Days Revisited – A DAX Coding Language Solution

Let's take another look at the problem discussed in this tutorial, which dynamically compared the first...

## Showcasing Multiple Selections In A Power BI Slicer

Many of you may know that we regularly conduct Power BI Challenges. There are lots of techniques that I...

## Microsoft Flows: Editing And Tracking In Power Automate

Once you understand how a Flow Diagram looks like, it will be easier to make some changes to it. In...

## Creating Power BI Reports Effectively & Avoiding Hidden Pitfalls

In this tutorial, I will discuss four hidden pitfalls in Power BI that can wreck your data model and/or...