Change range Y-axis

[louisquinet]

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 the range of my x and y-axis (which is now (0,Auto)) to (0,max + 5%). Does anyone know how I have to do this? I have no experience with functions in Power BI and after some trial and error I still don't know how to do it...

Thank you in advance
Louis

[Idrissshatila]

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]

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]

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]

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

[Idrissshatila]

@louisquinet ,

are you using field parameters ?

[louisquinet]

Yes 🙂

[Idrissshatila]

@louisquinet ,

can you show me the field parameters code

[louisquinet]

X axis = {

    ("Net Unit Price", NAMEOF('Pricing_Benchmark'[Net Unit Price]), 0),

    ("Maintenance Cost", NAMEOF('Pricing_Benchmark'[Maintenance Cost]), 1)

}

[Idrissshatila]

@louisquinet ,

the column names of the field parameters please.

[louisquinet]

Sorry I'm not sure that I understand your question right, do you mean
Net Unit Price

Maintenance Cost

?

[Idrissshatila]

@louisquinet ,

try this 

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

[louisquinet]

Thank you for your fast answer. When I try your code I receive the following error:

[Idrissshatila]

@louisquinet ,

try this

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

[louisquinet]

Thank you very much, the error message is gone.

I still have a problem:
So this is a screenshot about how it was before:

When I add "Range X-axis as conditional formatting, my graph disappears:

Do you have any idea why?

Thank you for all your help!

Louis

[Idrissshatila]

@louisquinet , click on the see details of the error and show me the error.

[louisquinet]

Sorry, of course 🙂 I forgot to send it.

[Idrissshatila]

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

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

)

[louisquinet]

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

[louisquinet]

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