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('Metr...
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.