Skip to main content
Microsoft Idea

Power BI

Completed

Nested X Axis Labels

Vote (281) Share
Mynda Treacy's profile image

Mynda Treacy on 21 Jan 2016 09:25:01

In a regular PivotTable we can nest axis labels e.g. we can group regional data by year. Currently PowerBI only supports one level of X axis labels.

There are loads of areas where this would be useful but one example is with the MailChimp campaign data which currently only allows you to list all the campaigns alphabetically. I want to group/sort by date. My only option is to use Slicers to filter out periods I don't want, but that doesn't really help me see them in date order.

Administrator on 15 Feb 2017 09:01:35

You can nest x-axis labels in column charts! You can read more about the feature here: https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-november-feature-summary/#hierarchicalAxis

Comments (38)
Mynda Treacy's profile image Profile Picture

Power BI User on 05 Jul 2020 22:36:46

RE: Nested X Axis Labels

Can't even start using Power BI without this?

Mynda Treacy's profile image Profile Picture

Justin on 05 Jul 2020 22:36:44

RE: Nested X Axis Labels

Something standard that I would have expected to already be included but here I sit without the use of this function. Not really fond of drilling down.

Mynda Treacy's profile image Profile Picture

Power BI User on 05 Jul 2020 22:35:15

RE: Nested X Axis Labels

WE NEED THIS!

Mynda Treacy's profile image Profile Picture

Darlene Shepherd on 05 Jul 2020 22:34:52

RE: Nested X Axis Labels

The chart does not know that 2015 December comes before 2016 January?

Mynda Treacy's profile image Profile Picture

Matt on 05 Jul 2020 22:34:51

RE: Nested X Axis Labels

If I understand this correctly, I can only plot by one measure of time (year, month, or day) but not in order of the 'date'??!!!

I was hoping Power BI would be a more cost-effective alternative to Tableau but you can't have such a fundamental feature as this missing..

Mynda Treacy's profile image Profile Picture

Iain Carlin on 05 Jul 2020 22:34:30

RE: Nested X Axis Labels

C'mon Microsoft. Graphs are pretty much useless without this ability. Please add this function to Power BI.

Mynda Treacy's profile image Profile Picture

Power BI User on 05 Jul 2020 22:33:40

RE: Nested X Axis Labels

can't beleive its not available yet...

Mynda Treacy's profile image Profile Picture

Ivan Szilva on 05 Jul 2020 22:33:04

RE: Nested X Axis Labels

essential to have.

Mynda Treacy's profile image Profile Picture

Helen.Gorina on 05 Jul 2020 22:32:23

RE: Nested X Axis Labels

absolutely nesessary
not having this feature is unexpected and disappointing

Mynda Treacy's profile image Profile Picture

Power BI User on 05 Jul 2020 22:31:56

RE: Nested X Axis Labels

We need to display both month and year on the x-axis. Please fix asap.