Forum Discussion

SteveWave's avatar
SteveWave
Frequent Visitor
1 year ago

Error Bars doesn't work with upper field value

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.

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    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.