Need to correct Y axis labels when Drilling Down

[Anonymous]

Hello all, when you drill down in graph, I don't want to show the previous level in label in the Y axis

For example, in the screen shot, I dont want it to say "Health Care System Amato, James A". I need it to just say "Amato, James A"

@edhans 

[Icey]

Hi @Anonymous ,

Is this problem solved?

Best Regards,

Icey

[Icey]

Hi @Anonymous ,

Do you mean that when you "expand all down one level in the hierarchy", previous levels' labels show too? Like below:

You can choose to use "go to the next level in the hierarchy". It only shows current level's labels.

If I misunderstood, please let me know.

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Right, but I want users to be able to just click on the graph itself, not have to use the Visual Header options

[Icey]

Hi @Anonymous ,

If you select the drill down icon to turn it on , clicking on the chart will drill down one field at a time. This won't show previous level's labels.

If you right click on the chart and choose "Show next level" or "Expand to next level", the effect is the same as using icons on visual header.

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[edhans]

You want to hide the Expand All Down (the single - to double arrow) and the Drill down (single down arrow) in the visual header and only use the Go to Next Level (two down arrows) button.

Then it will show one level at a time as they drill down and up.

Unfortunately you cannot see this hiding of the buttons in the desktop. You have to publish and see how it looks in the service. The desktop always shows all of the buttons in the Visual Header formatting section.

[Anonymous]

Okay I did that and it does not seem to have changed anything

@edhans 

[edhans]

as noted, disabling does not work in Power BI desktop. It always shows all buttons. You have to publish and look at it in the service to see what the end user sees.

[Anonymous]

Ahh okay I see, when I am in the power bi service online now I cannot click on the graph to drill down though.

A user needs to be able to click any part of the graph and drill down one level, but I dont want all of the labels on the Y axis to concatinate.

@edhans 

[edhans]

The double-down arrow allows them to drill down to the next level and didn't concatenate in my test. 

Otherwise, I think you may be out of luck with that visual. Not sure if any custom visuals would allow that kind of granular control in what they show.