cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ovonel
Post Prodigy
Post Prodigy

How to make y-axis dynamic?

I have this visual:

ovonel_0-1681375878507.png

 

 

The data changes based on filters… I want to make the Y-axis dynamic…

 

I want it to start from: minimum value-10 (rounded).

 

That is; from the above visual I want the y-axis from 60 to 100…

 

 

 

And on this one:

ovonel_1-1681375959162.png

The y-axis should be from 20 to 100.

 

Can this be achieved?

 

1 ACCEPTED SOLUTION
visheshjain
Super User
Super User

Hi @ovonel,

 

Try writing a measure and in the formatting pane, use this measure on the fx button of the min and max of the Y-axis, as per your requirement.

 

visheshjain_0-1681377888508.png

 

Did I answer your question?
If yes, then please mark my post as a solution!

Thank you,
Vishesh Jain

Proud to be a Super User!



View solution in original post

1 REPLY 1
visheshjain
Super User
Super User

Hi @ovonel,

 

Try writing a measure and in the formatting pane, use this measure on the fx button of the min and max of the Y-axis, as per your requirement.

 

visheshjain_0-1681377888508.png

 

Did I answer your question?
If yes, then please mark my post as a solution!

Thank you,
Vishesh Jain

Proud to be a Super User!



Helpful resources

Announcements
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Top Solution Authors