Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Dynamic y-axis for different clients

 

Hello,

 

I have a problem with automatic scale in graph, the problem is that always the scale starts in 0 and adjust the top. A solution could be to put a start and end value for the Y-axis manually, the problem is that in my datasets are different clients. The axis has to be different for all clients (filters).

I would like to do the next, +10% to the maximum and -10% as range for the y-axis. Or does anyone know another solution?

Thanks in advance

 

 

 

Show and Tell
  • v-gizhi-msft's avatar
    v-gizhi-msft
    6 years ago

    Hi,

     

    For your requirement, i have a workaround.

    If you choose line chart visual, you can set another Y2-axis.

    Please try this column:

    Column = IF('Table'[Value]=MAX('Table'[Value]),MAX('Table'[Value])*1.5,IF('Table'[Value]=MIN('Table'[Value]),MIN('Table'[Value])*0.5,'Table'[Value]))

    Then add it to line chart Y2-axis field, hide original Y-axis and display y2-axis, change this column color to white, it shows the new range:

    Tips: In this case, i have change +/-10% to +/-50% to display the new Y2-axis more obviously.

    The original Y-axis range:

    The new Y2-axis range:

    When you apply filter to the second visual, its Y2-axis will automatically changed by the current max and min value:(max * 1.5, min * 0.5)

    Hope this can help.

     

    Best Regards,

    Giotto Zhi

     

     

1 Reply

  • v-gizhi-msft's avatar
    v-gizhi-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi,

     

    For your requirement, i have a workaround.

    If you choose line chart visual, you can set another Y2-axis.

    Please try this column:

    Column = IF('Table'[Value]=MAX('Table'[Value]),MAX('Table'[Value])*1.5,IF('Table'[Value]=MIN('Table'[Value]),MIN('Table'[Value])*0.5,'Table'[Value]))

    Then add it to line chart Y2-axis field, hide original Y-axis and display y2-axis, change this column color to white, it shows the new range:

    Tips: In this case, i have change +/-10% to +/-50% to display the new Y2-axis more obviously.

    The original Y-axis range:

    The new Y2-axis range:

    When you apply filter to the second visual, its Y2-axis will automatically changed by the current max and min value:(max * 1.5, min * 0.5)

    Hope this can help.

     

    Best Regards,

    Giotto Zhi