Forum Discussion

Ahollis's avatar
Ahollis
Regular Visitor
2 years ago

Clustered bar chart negative value

Hello, any way to adjust the negative value as an absolute value for my bar chart below without impacting the source data?  i would like to see the bar to the right rather than the left....  
Need Help
Ahollis's avatar
Ahollis
Regular Visitor
2 years ago

Thanks Yulia this should work!  However what if my selected value is a Measure?  this is where the bar chart is pulling values from

 

  • v-weiyan1-msft's avatar
    v-weiyan1-msft
    Community Support
    2 years ago

    Hi Ahollis ,

     

    Based on your additional instructions, you can try code as below to create measure.
    My Sample:

    Amount = SELECTEDVALUE('Table'[Value])
    Actual MTD = CALCULATE(ABS([Amount]), 'Table'[Scenario] = "MTD" )

    Result is as below.

    Regarding the conditional formatting, use the following code to create a measure.

    Measure = 
VAR MTD_ = CALCULATE('Table'[Amount],FILTER('Table','Table'[Scenario] = "MTD"))
RETURN
IF ( MTD_ > 0, 1, 0 )

    Please refer to the previous reply for details about specific operation.
    Result is as below.


    Best Regards,
    Yulia Yan


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