Forum Discussion
How to Bold Specific Column Values in Power BI Table Visual.
Hi All,
I’m working on a table visual in Power BI and need help with formatting. I want to bold all the values in the “Target” column of the table. Is there a way to apply this formatting directly to just one column (not the entire row or table)?
I’ve tried looking through the Format pane but couldn’t find a direct option to bold only one column's values text and numeric values. Is there a workaround using conditional formatting or any DAX trick that can help achieve this?
Appreciate your guidance!
This is Sample Data.
Thanks you.
Your Target column have numbers and texts, thats why its say's cannot convert text to int.
Now i update the measure to include texts, please try it:BoldTarget = VAR RawText = SELECTEDVALUE(financials[Country]) RETURN IF ( ISBLANK(RawText), BLANK(), VAR LengthOfText = LEN(RawText) VAR Chars = ADDCOLUMNS ( GENERATESERIES(1, LengthOfText, 1), "@Char", MID(RawText, [Value], 1), "@Code", UNICODE(MID(RawText, [Value], 1)), "@BoldChar", SWITCH ( TRUE(), // Digits 0–9 → 𝟬–𝟵 UNICODE(MID(RawText, [Value], 1)) >= UNICODE("0") && UNICODE(MID(RawText, [Value], 1)) <= UNICODE("9"), UNICHAR(UNICODE("𝟬") + UNICODE(MID(RawText, [Value], 1)) - UNICODE("0")), // Uppercase A–Z → 𝗔–𝗭 UNICODE(MID(RawText, [Value], 1)) >= UNICODE("A") && UNICODE(MID(RawText, [Value], 1)) <= UNICODE("Z"), UNICHAR(UNICODE("𝗔") + UNICODE(MID(RawText, [Value], 1)) - UNICODE("A")), // Lowercase a–z → 𝗮–𝘇 UNICODE(MID(RawText, [Value], 1)) >= UNICODE("a") && UNICODE(MID(RawText, [Value], 1)) <= UNICODE("z"), UNICHAR(UNICODE("𝗮") + UNICODE(MID(RawText, [Value], 1)) - UNICODE("a")), // Percent sign MID(RawText, [Value], 1) = "%", "%", // Dot MID(RawText, [Value], 1) = ".", "·", // Hyphen MID(RawText, [Value], 1) = "-", "-", // Default: keep original MID(RawText, [Value], 1) ) ) RETURN CONCATENATEX ( Chars, [@BoldChar], "", [Value], ASC ) )Just assign your value to RawText variable, but make sure that is correctly formatted.
Thank you
7 Replies
- Bibiano_GeraldoSuper User
Hi Gopiraju404 ,
Power BI doesn’t currently support direct font style formatting (like bold) on individual columns in a table visual through the standard Format pane.
One approach, we can use, is to create a DAX measure to map this, assuming that you have a mesure named Target, please use this DAX:BoldTarget = VAR RawText = // Format the Target value as “0.00%” (two decimal places plus a percent sign) FORMAT ( [Target], "0.00%" ) VAR LengthOfText = LEN ( RawText ) // Create a virtual table of positions from 1 to the length of RawText VAR Positions = GENERATESERIES ( 1, LengthOfText, 1 ) // For each position, extract the single character, then map it to its “bold” Unicode equivalent VAR MappedCharacters = ADDCOLUMNS ( Positions, "@OriginalChar", MID ( RawText, [Value], 1 ), "@BoldChar", SWITCH ( TRUE (), // If it’s a digit “0”–“9”, calculate its bold‐digit codepoint: UNICODE ( MID ( RawText, [Value], 1 ) ) >= UNICODE ( "0" ) && UNICODE ( MID ( RawText, [Value], 1 ) ) <= UNICODE ( "9" ), // Bold zero ’𝟎’ starts at U+1D7CE; so: UNICHAR ( UNICODE ( MID ( RawText, [Value], 1 ) ) - UNICODE ( "0" ) + UNICODE ( "𝟎" ) ), // If it’s a decimal point “.”, replace with a middle dot “·” (visually similar to bold “.”) MID ( RawText, [Value], 1 ) = ".", "·", // If it’s a percent sign “%”, use the fullwidth/bold‐style percent “%” (U+FF05) MID ( RawText, [Value], 1 ) = "%", "%", // Otherwise, leave the character as is (e.g., minus sign, space, etc.) MID ( RawText, [Value], 1 ) ) ) // Concatenate all the mapped characters back in the original order RETURN CONCATENATEX ( MappedCharacters, [@BoldChar], "", // no delimiter [Value], // sort by position ascending ASC )Now instead of using your original target measure in the table, please use this one.
Your finally output will look like this:- Gopiraju404Frequent Visitor
I got error .
This is my exact sample data.
please help
Thank you.
- Bibiano_GeraldoSuper User
Your Target column have numbers and texts, thats why its say's cannot convert text to int.
Now i update the measure to include texts, please try it:BoldTarget = VAR RawText = SELECTEDVALUE(financials[Country]) RETURN IF ( ISBLANK(RawText), BLANK(), VAR LengthOfText = LEN(RawText) VAR Chars = ADDCOLUMNS ( GENERATESERIES(1, LengthOfText, 1), "@Char", MID(RawText, [Value], 1), "@Code", UNICODE(MID(RawText, [Value], 1)), "@BoldChar", SWITCH ( TRUE(), // Digits 0–9 → 𝟬–𝟵 UNICODE(MID(RawText, [Value], 1)) >= UNICODE("0") && UNICODE(MID(RawText, [Value], 1)) <= UNICODE("9"), UNICHAR(UNICODE("𝟬") + UNICODE(MID(RawText, [Value], 1)) - UNICODE("0")), // Uppercase A–Z → 𝗔–𝗭 UNICODE(MID(RawText, [Value], 1)) >= UNICODE("A") && UNICODE(MID(RawText, [Value], 1)) <= UNICODE("Z"), UNICHAR(UNICODE("𝗔") + UNICODE(MID(RawText, [Value], 1)) - UNICODE("A")), // Lowercase a–z → 𝗮–𝘇 UNICODE(MID(RawText, [Value], 1)) >= UNICODE("a") && UNICODE(MID(RawText, [Value], 1)) <= UNICODE("z"), UNICHAR(UNICODE("𝗮") + UNICODE(MID(RawText, [Value], 1)) - UNICODE("a")), // Percent sign MID(RawText, [Value], 1) = "%", "%", // Dot MID(RawText, [Value], 1) = ".", "·", // Hyphen MID(RawText, [Value], 1) = "-", "-", // Default: keep original MID(RawText, [Value], 1) ) ) RETURN CONCATENATEX ( Chars, [@BoldChar], "", [Value], ASC ) )Just assign your value to RawText variable, but make sure that is correctly formatted.
Thank you
- Gopiraju404Frequent Visitor
This is not working.
- Bibiano_GeraldoSuper User
Hi, Gopiraju404 !
Are getting error? can you please share what are you facing with above DAX?
- ajaybabuinturiSuper User
Hi Gopiraju404,
Power BI does not currently allow you to apply bold formatting directly to only one column's values via the Format pane.
But there is a workaround, you can make the values stand out by applying font color formatting like thisStep-by-Step:
Select the table/matrix visual.
Go to the "Target" column field > click the dropdown arrow.
Choose "Conditional formatting" > "Font color"
Choose "Field value" and provide a measure to return formatting.
TargetColor = IF(NOT(ISBLANK([Target])), "#000000", // black font "#AAAAAA" // gray/white if blank )5. You can set all other columns values are lighter grey as because we need to highilight the Target column. In this way you can highlight/bold the Target column values.
Thanks,
If you found this solution helpful, please consider giving it a Like👍 and marking it as Accepted Solution✔. This helps improve visibility for others who may be encountering/facing same questions/issues. - v-venuppuCommunity Support
Hi Gopiraju404 ,
Thank you for reaching out to Microsoft Fabric Community.
Thank you Bibiano_Geraldo ajaybabuinturi for the prompt response.
May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.
Thank you.