New Y-Axis on Drill Down - Clustered Column Chart

[donbro88]

Hi,

I am trying to create a Clustered Column Chart which shows a different Y-Axis when drilled down to the next level.

For example: At level 1, I just want it to show "Sum of Short Line PVT"

Whereas at the next level I would like it to show Sum of Shortage PVT.

At the moment it is showing both Y-Axis on every level.

Please help.

[vjb]

its an old post but just wondering if you were able to resolve it.  I am in the same boat and cant change Y axis

Thanks!

[Dhairya]

You can use Drill Down Bar chart from get more visuals in this case

please mark my solution as accepted if iy helped you!

[donbro88]

Hi, thanks for the input but this did not resolve the issue.

It is not possible to use the Drill Down Combo Pro Y-Axis. It shows both Y-Axis on the same graph.

The aim is to show one axis at level 1 and a different axis at level 2.

[Dhairya]

Hey @donbro88 can you please share your sample data which you want to plot?

[donbro88]

How do I share the test data?

[v-xinruzhu-msft]

Hi @donbro88 

You can create hierarchy, then put the field to the visual.

You can refer to the following link.

How to Create a Hierarchy in Power BI (Explained Simply) (spreadsheeto.com)

Best Regards!

Yolo Zhu

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

[donbro88]

Hi, thanks for the input but this did not resolve the issue.

It is not possible to use a Hierachy for a Y-Axis. It shows both Y-Axis on the same graph.