Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Solved! Go to 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
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
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!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
97 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |