Skip to main content

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 (36)
Mynda Treacy's profile image Profile Picture

f4eaf577 f827-475a-8997-7e8c38a12d17 on 05 Jul 2020 22:28:55

RE: Nested X Axis Labels

Only feature preventing us moving forward with PowerBI as our full time reporting tool.

Mynda Treacy's profile image Profile Picture

0b6aa5cf af2d-45dc-bd2a-7768998f4876 on 05 Jul 2020 22:25:00

RE: Nested X Axis Labels

please we need nested axis and a better drill down and drill up.

Mynda Treacy's profile image Profile Picture

e25e8a5a 3a99-426f-84d3-9f4d6dc4ff5e on 05 Jul 2020 22:24:58

RE: Nested X Axis Labels

The only reason I cannot start to make my reports with Power BI is that I cannot nest axis. I believe it would be a wonderful improvement.

Mynda Treacy's profile image Profile Picture

2cbab007 c5eb-42d5-8231-e280af5a6b08 on 05 Jul 2020 22:24:07

RE: Nested X Axis Labels

Yes, please! This is critical to my work, and at the moment I couldn't even consider Power BI because something as critical as this is missing.

Mynda Treacy's profile image Profile Picture

77a84312 0efa-4adf-8549-dfdb2f5a92d8 on 05 Jul 2020 22:16:46

RE: Nested X Axis Labels

I have been looking for this functionality everywhere! If it is available in Excel, why not PowerBI?

Mynda Treacy's profile image Profile Picture

0afa2f27 0ae2-4c4d-8b31-0d8bf88e28ea on 05 Jul 2020 22:15:51

RE: Nested X Axis Labels

Would love this as well. I'm using a stacked horizontal bar-chart, but I would like to "group" the x-axis variables based on another field. So it groups users by team for example. Now Í have to create a visual for every team seperately and have them filter only the users of a specific team.