Hierarchical Axis and concatenate labels

In this blog I will show you how you can set the format for hierarchical axis labels on the chart in a good way, also we will see how to concatenate labels property will help us to achieve this.?

The issue with the multi-Axis/ Hierarchical axis.?

- In the below Image there are 3 levels of hierarchy in Axis, and they are – year, quarter & month.?

Follow these steps to create a multi-Axis:

?Step-1:?Import any?dataset. After loading data into the Power BI file, check the datatype for the Date column, if the datatype is not in date format, then change it as in date.

Step-2:?Add one stacked column chart, add drag columns as mentioned below-

Axis:?Date

Legend:?Country

Values:?Sales

By default, it will display the first level of hierarchy data on the chart on the X-axis. After that click on the “Expand all down.” icon (Green highlighted icon) to display one more level of hierarchy on the chart. Similarly, click to the last level of the hierarchy.

Step-3:?Now all three levels of hierarchies are visible on the x-axis.

Step-4:?Now sort the chart data by year, quarter & month. click on?ellipses and then select Sort axis >Year Quarter Month and Make sure the sort order should be?ascending.

Step-5:?Now turn off?concatenate labels-?Go to?the formatting pane from?the X axis?and?turn off?concatenate labels.

Step-6:?To view the hierarchy more clearly, change the Gridlines of the X-axis to solid.

Now you can see in the above Image, that it looks good and is easy to read.

Thank you for reading!

Rahul Prajapati

Data Analyst

Addend Analytics

Addend Analytics?is a Microsoft Gold Partner based in Mumbai, India, and a branch office in the U.S. Addend has successfully implemented 100+ Microsoft Power BI and?Business Central?projects for 100+ clients across sectors like Financial Services, Banking, Insurance, Retail, Sales, Manufacturing, Real estate, Logistics, and Healthcare in countries like the US, Europe, Switzerland, and Australia. Get a free consultation now by emailing us at?[email protected]?or?Contact us.