Drill down column names

[gbat]

Hi 

I am fairly new to Power BI so please forgive what may be a fairly basic question.  I have 4 visualisations on a page which are showing various facts about a workflow system we have and where workflows are in the process.   Our company hierarchy is

Business Unit (e.g. Property)

Division (eg. Corporate)

Team (eg. US)

Handler. (eg. GBAT)

On one of the visualisations when drill down from Business Unit (Property), the report column name then just shows the division 'Corporate' and then when I drill down from there it goes to 'US' and so on.

However on another visual I have I don't lose the parent I drilled down from so I get columns names:

Property <drill down to> 

Property Corporate <drill down to>

Property Corporate US <drill down to>

Property Corporate US GBAT

In reality our unit names are much longer so by the time you have drilled down 3 levels all the user can effectively see is the first two levels.

Can anyone advise how to lose the repeating prefixes from the parent drill down?

Many thanks 

GBAT

[Greg_Deckler]

Use the double arrow drill down, not the branched double arrow drill down. Might depend on the visualizations. Which visualizations are you using and on which one are you getting the behavior?

[fish3101]

Hi there....I have been having a similar issue however re-creating the visual did not solve the problem for me. One additional 'interesting' element to our problem is it only presents as an issue after we've used the chiclet slicer to filter the bar graph. Prior to this the drill through column names don't show.

Anyone else seen this issue?

[gbat]

Hi fish3101

Whilst I still don't know what caused it I have got round it (but I can't remember which way round) by removing and then re-adding all the data elements (Axis, data, etc.) from either too element down or bottom element up.

[Roberto456]

I am currenlty have this issue, is there no way to get rid of these parent names?

[sd_09]

Hi @Roberto456 did you resolve this issue?

[gbat]

Hi smoupre,

Thanks for the response - both my visualizations are Clustured column charts (the one going wrong has Legends; the other doesn't) I have tried to insert a screenshot but that did not work.

Unfortunately I'm not quite sure what you mean by double arrow or branched double arrow - is that smoething on the right click menu?

[gbat · Accepted solution]

Hi again

I have managed to resolve the issue by recreating the visualization from scratch. So not quite sure what i did wrong.

Anyway thanks for your help.