Forum Discussion

louisquinet's avatar
louisquinet
Helper II
2 years ago

Change range Y-axis

Hello In my scatter chart the highest value is not very visible. It is always at the maximum and because of that you can only see half a circle or even a quarter of a circle. I would like to change ...
Need Help
Idrissshatila's avatar
Idrissshatila
Super User
2 years ago

HEllo louisquinet ,

 

create a measure to calculate the number of current + 5% and add it in the fx in the maximum to be dynamic.

  • louisquinet's avatar
    louisquinet
    Helper II
    2 years ago

    Thank you very much! It works 🙂

    I still have an aditional question.

    I have the possibility to change my x-axis as you can see on the screenshot. At this moment it works perfectly for the net unit price but when I change it to maintenance cost (which is mucg lower) it keeps the same range for the x-axis which is really not convenient. Do you know how to do change this?

     

     

     

     

    • Idrissshatila's avatar
      Idrissshatila
      Super User
      2 years ago

      Hello louisquinet ,

       

      try this instead of your measure and specify the number you want to multiply the value with in the second condition

      Measure = 
SWITCH(
    TRUE(),
    ISFILTERED('Pricing_Benchmark'[Net Unit Price]) = TRUE(), 1.05 * SELECTEDVALUE('Pricing_Benchmark'[Net Unit Price]]),
    ISFILTERED('Pricing_Benchmark'[Maintenance Cost]) = TRUE(), 2 * SELECTEDVALUE('Pricing_Benchmark'[Maintenance Cost]),
    // Add more conditions as needed
    BLANK() // Default value if no conditions are met
)

       

      • louisquinet's avatar
        louisquinet
        Helper II
        2 years ago

        Hello

        Thank you for your fast answer!

        I tried what you told me, you can see the screenshots bellow, but unfortunatelly it is again like before. The maximum of the range is the max value and not the max value *1.05.
        Do you know what I did wrong or what I should change to make it work?
        Thank you in advance

        Louis