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

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. 😞