Dynamic axis for multi-view charts | Microsoft Power BI

 

Dynamic axis for multi-view charts

How often have you taken a step back from a dashboard and thought – too many charts?

Problem is, the client wants them all!

A sleek solution often used by the White Box team is to implement dynamic axis charts for our clients, particularly those in C-level and managerial positions who oversee many functions and operations at once.

Dynamic axis charts are a custom-built solution in Power BI which allow users to toggle between variables on either the X or Y axis of charts. The user can quickly jump between views, without having to jump between report tabs.

Our client needed a CEO-view dashboard of the key metrics of their business. Because of the vastness of the data available, and the multiple points it could be analysed from, they needed a solution which enabled easy navigation between a number of key charts without leaving the main dashboard page.

This was a perfect opportunity to implement the dynamic axis. Utilising upwards of 4 variables on one axis against a fixed variable on the other, they could easily switch to charts of most interest, all in a single, uncluttered dashboard view.

Trial out the dynamic axis chart with this simple example using cricket statistics.

 

Digital transformation with White Box

White Box Analytics specialises in helping businesses map out their digital transformation journeys with data, ensuring the right projects are completed first in order to provide the framework for more advanced developments in the future. We can help across a range of key areas including:

  • understanding your businesses goals to create a strategic data roadmap

  • audit and assess your data assets to understand its potential

  • data manipulation and modelling

  • data visualisation and insight reporting

  • machine learning and AI.

If you’d your business to become masters in reporting, analytics, AI and more, reach out to our team of experts today for a conversation on how we can help you succeed!

Interested in White Box Analytics’ visualisation products or support model? Start a conversation with us today to learn more about how we can empower your team.

Featured
update table 2.png
AFL 2023: Risers and Sliders

After a long off-season, the AFL season is here! What better way to celebrate than by making some bold, data-driven predictions about the biggest movers of the upcoming season.

Data Mesh - The future for data led organisations
Data Mesh - The future for data led organisations

The main obstacle with any developed data analytics function is the bottleneck of data and skillset – the more central intelligence you have, the more outer teams want to use it, so you need to find a way of allowing data and insights to flow.

If data is so complex that only your highly paid data wizards, how can make sense of it?

Here’s one methodology that we’ll discuss in detail, the Data Mesh:

  1. A decentralised data structure with domain/product teams who own the analytical and operational data:

  2. Self-serve infrastructure, data products and federated governance.

  3. A data-driven decision-making culture across the organisation.

Using data to predict movie ratings
Using data to predict movie ratings

With the Oscars just round the corner (March 12th), it seems fitting to keep on top of the latest movies and see if data can help find the diamonds in the rough!

In my previous article I looked at upcoming sequels, with a lens of which movies would come out on top. A question that kept coming back was “can we predict how non sequel movies are going to do (rating wise)?”

Where there is data, we find an answer!

finalupdate.png
NRL 2023: Movers and Shakers

After a long off-season, the NRL season is here! What better way to celebrate than by making some bold, data-driven predictions about the biggest movers of the upcoming season.

Ribbon chart.png
Gender and jobs, are we heading in the right direction?

The Australian Bureau of Statistics released the 2nd round of Census data on topics including employment and location-based variables in Oct2022. Our last article focused on the gender pay gap, so this time, we’ve used occupation data by age and gender to further enhance our understanding of this topic.

The most anticipated movies of 2023
The most anticipated movies of 2023

There are some BIG movies on the horizon this year – some where we know the characters like old friends and others that will introduce new heroes and villains (I really don’t know what to make of the new horror Winnie the Pooh movie).

Christmas - a time to watch TV?
Christmas - a time to watch TV?

The Christmas break offers so much - from family reunions, beach activities to stuffing ourselves with more food than would normally be appropriate.

If like me, you feel a bit overwhelmed by the choice of TV shows to catch up with, let’s use data to our advantage and make sure you cover off the biggest shows from the last few years!

AU retail sales over last 10 years (excluding Dec).png
Black Friday: Big deal or no deal?

Black Friday (25th Nov) is a global event and something consumers and retailers look forward to every year.

In the last 3 years, we can see how much Electronic goods and Clothing retail have really taken advantage of Black Friday and look to be outpacing Department stores for uplift.

wgea1.jpg
Mind the gap: the disparity in gender pay goes on

We’re all aware that there is a gender pay gap but are certain areas more prone to it? We look at high earners across Australia using the 2021 Census data.

no_ball1.jpg
T20 World Cup: Cricket loves a rivalry, and a debate

The T20 Cricket World Cup is underway and was marked on Sunday by a sensational game between unyielding rivals India and Pakistan, with an epic finish that left everyone speechless.

 
Guest User