Forum Discussion
Adding Bullet point as a prefix to a column
You can use the UNICHAR function.
Great, thank you so much. Worked for me. I have another question i have a finance report and want to show negative values in red and brackets. But when i format the values to include brackets - it chnages the format to text and my calculations break. Can i use unichar function for this too?
Hi Sheenam,
You can use the custom formatting pane for that. In the past you would have to use the formatting function and indeed, it would transform the field to a text field. However, with the custom formatting box this downside has been solved. I recorded a video on how to do just that:
https://gorilla.bi/power-bi/display-negative-numbers-between-parentheses/
Hope that helps!
Rick
--------------------------------------------------
@ me in replies or I'll lose your thread
Master Power Query M? -> https://powerquery.how
Read in-depth articles? -> BI Gorilla
Youtube Channel: BI Gorilla
If this post helps, then please consider accepting it as the solution to help other members find it more quickly.