Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

How to Set different Y-Axis Range for Chart

Hi power bi gurus, 

The below image is the ideal y-axis range for our data. But when as we drill up we can't use the same range as it sums up and it will look weird. (the other two images). 

a) Can we set different ranges for different levels of drill up/down? 
b) Or should we disable the drill up and down mode? If possible and how? 
c) Any other solutions? thanks. 

Appreciate any help. Thanks. pbix 

 

  • Hi Anonymous 

    This is the logic behind every hierarchical visualization:

    • You see aggregations according to the chosen hierarchy level.
    • It is possible to hide the drill-down buttons (see attached image).
    • On the desktop, the buttons will still be visible in the panel, but the user will not see them

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

     

1 Reply

  • Hi Anonymous 

    This is the logic behind every hierarchical visualization:

    • You see aggregations according to the chosen hierarchy level.
    • It is possible to hide the drill-down buttons (see attached image).
    • On the desktop, the buttons will still be visible in the panel, but the user will not see them

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