Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Dynamically control y axis minimum and maximum for column chart.

Hi all,

I've been asked to Dynamically control y axis minimum and maximum for column chart. 

 

f I could drop a measure in the min and max formatting option this would also be easy, but I can't see that I can do that. Any thoughts?

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago
    Well, the simple answer is: YOU CANNOT. Either you hard-code the values or you set it to Auto letting PBI do it for you.

    Best
    D
    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Thanks..

    • Rikirk's avatar
      Rikirk
      Regular Visitor
      4 years ago

      Added a column with the calculated value i wanted to show as minimum y value, then selected the column as average, works perfectly.

  • Ewoud1234's avatar
    Ewoud1234
    New Member
    4 years ago

    At the moment it is possible to put a measure for min and max column charts. You could use parameters for example to make this dynamically.