Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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..
got the solution.
In Number formatting --> Custom and Format Pattern #,##0.00;#,##0.00
did the same changes for both the expressions.
Hi
have a look to the fabs() function to get absolute value
Regards
got the solution.
In Number formatting --> Custom and Format Pattern #,##0.00;#,##0.00
did the same changes for both the expressions.