Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
ggordon
Frequent Visitor

Random Brackets on Positive Numbers

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!

 

brackets.png

1 ACCEPTED SOLUTION
samdthompson
Memorable Member
Memorable Member

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

// if this is a solution please mark as such. Kudos always appreciated.

View solution in original post

2 REPLIES 2
samdthompson
Memorable Member
Memorable Member

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

// if this is a solution please mark as such. Kudos always appreciated.
Sean
Community Champion
Community Champion

@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!

 

 

2016-10-18 - Pie Chart - Detail Labels.png

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.