Forum Discussion

Petr_M's avatar
Petr_M
Frequent Visitor
4 years ago
Solved

Dynamically calculated Y axis maximum (extra space over max displayed value)

I have a measure.     Ratio = sum(Table[A])/sum(Table[B])     I want to plot the Ratio in a chart that has an Y axis with the following idea:     MaxY = max(Ratio)*1.3     so that the...
Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    Petr_M , Using the column used on x-axis

     

    MaxY = maxX(Values(Table[Col]) ,[Ratio])*1.3
amitchandak's avatar
amitchandak
Super User
4 years ago

Petr_M , Using the column used on x-axis

 

MaxY = maxX(Values(Table[Col]) ,[Ratio])*1.3
  • Petr_M's avatar
    Petr_M
    Frequent Visitor
    4 years ago

    Works like a charm! Thanks a lot, amitchandak!

  • Petr_M's avatar
    Petr_M
    Frequent Visitor
    3 years ago

    If I may have one more question, amitchandak , is it possible to also modify the formula so that it looks at A instead of Ratio? If simply replaced like this:

    MaxY = maxX(Values(DimCalendar[Ultimo]) ,Table[A])*1.3

    I get an error message: "A single value for column 'A' in table 'Table' cannot be determined. This can happen when a measure formula refers to a column that contains many values without specifying an aggregation such as min, max, count, or sum to get a single result."

    I tried to fix it by adding a sum, but it seems to sum also over all ultimo values.

    Thanks.