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
louisquinet's avatar
louisquinet
Helper II
2 years ago

Sorry, of course 🙂 I forgot to send it.

 

Idrissshatila's avatar
Idrissshatila
Super User
2 years ago

louisquinet ,

try this

Measure = 
SWITCH(
    TRUE(),
    SELECTEDVALUE('X axis'[order]) = 0, 1.05 * SELECTEDVALUE('Pricing_Benchmark'[Net Unit Price]]),
    SELECTEDVALUE('X axis'[order]) = 1, 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

    Hi!

    Thank you for your answer!
    Power BI gives me this error message: Column 'order' in table 'X axis' cannot be found or may not be used in this expression. 😞

     

  • louisquinet's avatar
    louisquinet
    Helper II
    2 years ago

    I remarked that "X axis order" and "X axis fields" possible, but they both don't work 😞

  • louisquinet's avatar
    louisquinet
    Helper II
    2 years ago

    I see that in my last message was a fault from me, but it still does not work...
    This is what I tried now:

    Range X-axis =
    SWITCH(
        TRUE(),
        SELECTEDVALUE('X axis'[X axis Order]) = 0, 2 * SELECTEDVALUE('Pricing_Benchmark'[Net Unit Price]),
        SELECTEDVALUE('X axis'[X axis Order]) = 1, 2 * SELECTEDVALUE('Pricing_Benchmark'[Maintenance Cost])
    )