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 maximum value has extra space obove regardless any slicers applied.

Seems simple but I was unable to find the solution so far.

Thanks a lot!

 

Need Help

3 Replies

  • 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

      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.