Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hello
I am in need to present a bar chart with dynamic data lables (data lables drived by dax). to acheive that I have use external tool called tabular editor. with this i written format string expression.
The requirement is i need to concadiante '-' for negative values and '+' for positive values and also % for some attributes.
below i present the dax in tabular editor Ver.2
Here i used format string expression to customise the data lable
this is output. we can clearly see double '-' symbol at the first value but for others all is fine.
I need help regarding this
I found your topic @Aakash15 while searching for an answer for my dynamic format problem, because i got two -- for negative values. I found an answer for my dynamic formatting with some behaviour testing.
E.g. i wanted following format, but for negative Values i got "-- XXX K":
"""" & FORMAT(SELECTEDMEASURE(), "#,0, K")
Then i tested where this second - came from. I recognized, that PowerBI adds an "-" infront of my Format(...). With following code, the result was "- -XXX K"
" " & FORMAT(SELECTEDMEASURE(), "#,0, K")
So i wanted to get rid of one minus. I achieved that with formatting negativ values like positive ones, because it adds an "-" before Format(). This works for me:
"""" & FORMAT(SELECTEDMEASURE(), "#,0, K;#,0, K")
Eventhough the answer is pretty late, i hope this helps you or someone else!
@Aakash15 , In the format function you have options for positive and negative values
https://learn.microsoft.com/en-us/dax/format-function-dax#custom-numeric-formats
Just use \+ on positive value at start
example
\+#,###.00
or try
+#,###.00
Hello Amit,
Really thanks for Reply. but unfortunatly it doesn't solve the issue. i went with bit of hardcoaded way, right now its fine but with no surity, I ll be glad if you can help with any other solution to it.
Thankyou.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
102 | |
68 | |
66 | |
52 | |
41 |
User | Count |
---|---|
159 | |
82 | |
65 | |
64 | |
61 |