Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Anonymous
Not applicable

Adding Bullet point as a prefix to a column

Hi all

 

I need to add bullet points as prefix to a column text in power bi table. Can anyone help me achieve this. I can't use a text box as i am unable to pass column value in text box

1 ACCEPTED SOLUTION
Greg_Deckler
Super User
Super User

You can use the UNICHAR function.


Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

4 REPLIES 4
Greg_Deckler
Super User
Super User

You can use the UNICHAR function.


Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

You can use the UNICHAR function? 

 

I'm working in a text box making a list of questions to answer in my data.  So, I thought I'd check to see if I could find any easy way to add bullet points.

 

It's hard for me to imagine a less useful answer than Use the UNICHAR function.  Where would I use the Unichar function in a text box??

 

Here's an answer from somebody who's actually trying to be useful.

And yes it's way to long, so I'm just going to copy bullet points out of Word.  But at least it's not a smiling generality that can't do anything except generate ticked off responses from other members.

 

Using Unicode Characters in Power BI by Soheil Bakhshi Microsoft Data Platform MVP

In this post I explain how you can use Power BI as a tool to generate almost all valid Unicode characters in Power BI. You can download the PBIT at the bottom of this post. Then you can copy the Unicode characters from Power BI and use them in all textual parts of your report like visual titles, text boxes and so on.

The Unicode planes start from 0 to 1,114,111 which is decimal equivalent of 0 to 10FFFF in hexadecimal numeral system. For more information on Unicode planes check this out.

So, a simple way to generate all possible Unicode characters is to generate a list of decimal numbers starting from 0 ending at 1,114,111. This way we generate a series of decimal numbers regardless of the gaps between starting and ending Unicode blocks. Then using UNICHAR() function in DAX to generate corresponding Unicode characters. With the following DAX expression you can easily generate a list and the corresponding Unicode characters:

Generate Unicode = 
SELECTCOLUMNS(
  ADDCOLUMNS(
      GENERATESERIES(0, 1114111, 1)
    , "Unicode Character"
    , IFERROR(UNICHAR([Value]), "Not Supported")
     )
, "Decimal Value", [Value]
, "Unicode Character", [Unicode Character]
)

 

Anonymous
Not applicable

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.

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

Top Solution Authors
Top Kudoed Authors