Error Bars doesn't work with upper field value

[SteveWave]

Dear Community,

I tried to use the error bar option to illustrate the increase/decrease from the previous to current current month.

My Measure-2 =

IF(

    SELECTEDVALUE('Metric-2'[Metric-2]) = "Current Month",

    [Sales_total],

    [Prev month Sales]

    )

Therefore, I used for the error bar field value the following measure:

Upper =

IF(

    SELECTEDVALUE('Metric-2'[Metric-2]) = "" &&

    [Prev month Sales] < Sales[Sales_total],

    Sales[Sales_total], BLANK()

)

 

Unfortunately, it doesn't show up any bar. With the percentage options it perfectly works and correctly shows the bars.

Is there something wromg with the syntax of the upper measure ?

Best and thanks for your help.

[Anonymous]

Hi @SteveWave 

I suggest you change the code to look like this:

Upper =
IF(
    SELECTEDVALUE('Metric-2'[Metric-2]) = "Current Month" &&
    [Prev month Sales] < [Sales_total],
    [Sales_total], 
    BLANK()
)

If you're still having problems, provide some dummy data and the desired outcome. It is best presented in the form of a table.

Regards,

Nono Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.