Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
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!
You can use Drill Down Bar chart from get more visuals in this case
please mark my solution as accepted if iy helped you!
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.
How do I share the test data?
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.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
101 | |
76 | |
64 | |
63 |
User | Count |
---|---|
141 | |
104 | |
101 | |
80 | |
67 |