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

    08deb6bf 7ace-ea11-a812-000d3a579c38 on 25 Jul 2020 13:30:07

    RE: Nested X Axis Labels

    Please fix this function!

    Mynda Treacy's profile image Profile Picture

    55004a93 8c65-4876-8a4b-f16a18f6c4fb on 06 Jul 2020 00:07:42

    RE: Nested X Axis Labels

    Is this also available on Power BI Report Server? If not, when..? We are using Sept 2019 version now.
    I saw it on a Pbi file from a coworker, but I cannot replicate it in Power BI Report Server: I do not see the Concatenate toggle..?

    Mynda Treacy's profile image Profile Picture

    c685967b bf0a-42a0-8bf9-432733235b67 on 06 Jul 2020 00:04:07

    RE: Nested X Axis Labels

    Nested X Axis doesn't work as the completed admin solution demo'd.

    Mynda Treacy's profile image Profile Picture

    c685967b bf0a-42a0-8bf9-432733235b67 on 06 Jul 2020 00:04:07

    RE: Nested X Axis Labels

    Right click your bar chart and expand to next level. that is all you need

    Mynda Treacy's profile image Profile Picture

    022af498 b6f4-432a-93cf-d51d5964975b on 05 Jul 2020 23:49:19

    RE: Nested X Axis Labels

    Is anyone having an issue with Nested X Axis Labels? I can't get this to work even when following the instructions.

    Mynda Treacy's profile image Profile Picture

    de1e6f64 56cd-4f90-9a12-580420b3df80 on 05 Jul 2020 23:24:07

    RE: Nested X Axis Labels

    This is an extremely common use case available in all other data visualization tools I've used. This is a show stopper in moving from SSRS (Paginated reports) to Power BI Server.

    Mynda Treacy's profile image Profile Picture

    5bf54a43 419d-4954-aab6-8fc40c0450a1 on 05 Jul 2020 22:40:48

    RE: Nested X Axis Labels

    Thank you PowerBI team! This will really help us. One less excuse not to be using PowerBi.

    Mynda Treacy's profile image Profile Picture

    cbe3ed87 1f0c-4c8f-82a1-81845b88d3ad on 05 Jul 2020 22:40:45

    RE: Nested X Axis Labels

    I've spent the past day trying to figure a work around. This is CRUCIAL for historic prices by date and a way for a relationship connection to work with it around the name of the price.

    Mynda Treacy's profile image Profile Picture

    da66ae79 d998-4018-a4e8-ff389cca0709 on 05 Jul 2020 22:39:50

    RE: Nested X Axis Labels

    This functionality is critical to the business, especially since my data will be looking at period over period and year over year turnover.

    Please!!!!!

    Mynda Treacy's profile image Profile Picture

    4556428d c73a-4d0f-a266-67216fa08cdf on 05 Jul 2020 22:39:35

    RE: Nested X Axis Labels

    WE NEED THIS, PLEASE ADD!