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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

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
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

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

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

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