topic Re: Value labels coming in negative in a bar chart in App Development

Value labels coming in negative in a bar chart

Navars — Fri, 28 Jan 2022 08:48:28 GMT

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 — Fri, 28 Jan 2022 09:31:22 GMT

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

Regards

Navars — Fri, 28 Jan 2022 12:48:27 GMT

got the solution.

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

did the same changes for both the expressions.