Forum Discussion

ravagarw's avatar
ravagarw
New Member
9 years ago

Enable/Disable hierarchy labels in Visual

Hello,

 

I have created a PBI model containing few charts.

These charts have a drill down hierarchy as Region,Business Unit,Project

 

When I drill down to the next level the label of the previous level is appended and makes the chart clumsy and difficult to read.

 

Example:

In the Below image, NA is the region, RC is the business unit and E100004448 is the Project code and I am at the Project level.

Here I want to see just the Project code in the label.

 

 

Show and Tell

3 Replies

  • v-ljerr-msft's avatar
    v-ljerr-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    9 years ago

    Hi ravagarw,

     

    Could you try turning on Concatenate labels for the X-Axis under the Format panel to see if it works? :smileyhappy:

     

     

    Regards

    • ravagarw's avatar
      ravagarw
      New Member
      9 years ago

      Hello ,

       

      Thank you for the response, but this solution does not work.

       

      I have 2 charts but this issue is happening only with one of them although both of them are same(line charts).

      Unable to find out why this issue is only in one.

      • v-ljerr-msft's avatar
        v-ljerr-msft
        Icon for Microsoft Employee rankMicrosoft Employee
        9 years ago

        Hi ravagarw,

         

        A little weird. Could you share a sample pbix file which can reproduce this issue if possible? So that we can help further investigate on it. You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading. :smileyhappy:

         

        Regards