Forum Discussion

Aakash15's avatar
Aakash15
New Member
3 years ago

need help with resolving double '-' symbol from dymanic datalable using tabular editor

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 expr...
Need Help
timtack's avatar
timtack
Frequent Visitor
3 years ago

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!