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

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

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])
)