Drill down column names

[cbouichi]

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

[parry2k]

@cbouichi check if turning off concatenate labels get you what you are looking for?

[cbouichi]

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

Regards,

Charaf

[parry2k]

@cbouichi 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.

[cbouichi]

@parry2k  thank you for your quick reply.

I turn the concatenate labels off but nothing happend.

[parry2k]

@cbouichi 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.

[cbouichi]

That didn't work for. Any other suggestions?

[parry2k]

@cbouichi hmmm it is working for me. what visual you are using? What version of powerbi you are using?

[cbouichi]

@parry2k  i'm using the latest version and its a stacked column chart.

Are you using 2 different tables in your examples?

[parry2k]

@cbouichi nope, it is just one single table, although that doesn't matter.