Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Drill down column names

Hi everybody,

 

I have a stacked column chart. When i drill down the column names keep adding up. I dont want this because because when i reach drill down level 3 you cant read the columns names anymore.

 

Hierarchy didnt work for me because the chart contains out of 2 tables.

I cant join the tables because of the breakdown structure.

Going to the next level with the double arrow icons doesnt work for me also because it let me see all te records and not the filter ones.

 

Can somebody help me to get the desire outcomes.

In short drill down with the orginel column names.

 

Kind regard,

Charaf

9 Replies

  • Anonymous check if turning off concatenate labels get you what you are looking for?

    • Anonymous's avatar
      Anonymous
      Not applicable

      parry2k  thank you for your quick reply.

       

      I turn the concatenate labels off but nothing happend.

       

      • parry2k's avatar
        parry2k
        Super User

        Anonymous try sorting your visual by y-axis column and then sort it back by column on x-axis. You can change thes sort by clicking on 3 dots on top right corner of your visual. Give it a try.

    • Anonymous's avatar
      Anonymous
      Not applicable

      I still looking for a solution. i dont understand why it dont work for me.

       

      Regards,

      Charaf

      • parry2k's avatar
        parry2k
        Super User

        Anonymous as shown earlier, it is working, not sure the issue at your end. Share pbix file to look into it, remove any sensitive information before sharing.