Value labels coming in negative in a bar chart

[Navars]

Hi All,

i have requirement like, need to show top5 and bottom 5 values based on a city(City is  a Dim here) in a Bar chart. 

for that i have created two measure like below.

for top 5 : Count({<City={"=rank(count(PatientID))<=5"}>}PatientID)

Bottom 5 :  -Count({<City={"=rank(-count(PatientID))<=5"}>}PatientID)

and, chart coming like below as expected but for bottom 5 values Value label coming in -ve i need to those values also in +ve only.

Thanks in Advance..

[brunobertels]

Hi 

have a look to the fabs() function to get absolute value 

Regards 

[Navars · Accepted solution]

got the solution.

In Number formatting --> Custom and Format Pattern #,##0.00;#,##0.00

did the same changes for both the expressions.