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
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!
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
113 | |
96 | |
92 | |
87 | |
69 |
User | Count |
---|---|
161 | |
126 | |
119 | |
109 | |
95 |