cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
gbat Frequent Visitor
Frequent Visitor

Drill down column names

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

 

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
gbat Frequent Visitor
Frequent Visitor

Re: Drill down column names

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.

 

 

5 REPLIES 5
Super User
Super User

Re: Drill down column names

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?


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


gbat Frequent Visitor
Frequent Visitor

Re: Drill down column names

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 Frequent Visitor
Frequent Visitor

Re: Drill down column names

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.

 

 

fish3101 Frequent Visitor
Frequent Visitor

Re: Drill down column names

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 Frequent Visitor
Frequent Visitor

Re: Drill down column names

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.