Random Brackets on Positive Numbers

[ggordon]

Hello,

Some of my visuals are wrapping numbers in brackets and I don't know why.  None of these numbers are negative.

Does anyone have any ideas?  See image below,

thanks!

[samdthompson · Accepted solution]

Hi, you have done nothing wrong. Its a presentational failsafe so that if you had a label which was for example '5' and the result was 5% then if it were on one line with no parentheses it would look like 5 5%. Not a great result. You can see that if the label is on a second line its not in the brackets.

To work around it if you need to try putting the value in as a tooltip. You might need a FIRSTNONBLANK(Value , 1) to make the tool tip work sucessfully. You might also need to turn off the value on the piechart values label.

// if this is a solution please mark as such

[Sean]

@ggordon

My experience has been that this happens when you have the Detail Labels for a pie chart display BOTH Category and Data Value!

Then depending on whether the Category (Data Value) fit on the same line => the Date Value is in parentheses ( )

If the Data Value does not fit on the same line it is placed below the Category and it is not in parentheses ( )

In some cases adjusting the dimensions of the visual can take care of this but as soon as you use a slicer or filter the data by another visual you will get the same behavior!