Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

X Axis Label Hierarchy

Hey I have seen a lot of posts about this and it is still not working for me. I have a hierarchical structure in a clustered column chart. When I turn on "Drill Down" and select what I want to drill into all the x labels in the lower level include the label before.

I have turned off "Concatenate Labels in the x-axis and I am also sorting by the hierarchical structure.

 

Any help would be appreciated, I have the October 2019 version

Need Help
  • v-xicai's avatar
    v-xicai
    6 years ago

    Hi Anonymous ,

     

    In your scenario, when you turn on drill-down mode , turn off "Concatenate labels" in the x-axis and click on a bar in the graph, the returned result is just like below.

     

     

    If you would like the labels of red box above to disppear, then try to turn on the "Concatenate labels" in the x-axis.

    Best Regards,

    Amy

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Anonymous's avatar
    Anonymous
    6 years ago

    Hey Amy,

     

    So this what I am trying to solve for essentially. The drill-down starts with Region then Manager. When I turn on drill down and click on a region it says "West Manager 1".

     

    This is with concatenating labels turned off and then also with it on it does the same thing. Thank you for all your help v-xicai 

4 Replies

  • v-xicai's avatar
    v-xicai
    Community Support
    6 years ago

    Hi Anonymous ,

     

    By my test in the latest version 2.74.5619.862 of Power BI Desktop, when try to click on the highlighted button to drill down, the "Concatenate Labels" option works well.

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

    Best Regards,

    Amy

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Yes, that also works for me. But if you turn on drill-down mode and click on a bar in the graph it is concatenating the labels

      Is there a way to turn that off?

      v-xicai 

      • v-xicai's avatar
        v-xicai
        Community Support
        6 years ago

        Hi Anonymous ,

         

        In your scenario, when you turn on drill-down mode , turn off "Concatenate labels" in the x-axis and click on a bar in the graph, the returned result is just like below.

         

         

        If you would like the labels of red box above to disppear, then try to turn on the "Concatenate labels" in the x-axis.

        Best Regards,

        Amy

         

        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.