Bold the values in just one column of a matrix

[ldwf]

I want to bold the font of values in just one column of a matrix (i.e, every row in one column), but I don't see any option for doing that. Is it possible to do this? I have seen a few posts about html tags and how that might help, but I haven't seen anyone say it resolved their issue.

[Anonymous]

Hi @ldwf , hello Bibiano_Geraldo and lbendlin, thank you for your prompt reply!

Please create a measure with svg code as shown below:

Formatted_Cost = 
VAR FontWeight =
     "bold"
VAR txt=MAX('Table'[Cost])
RETURN
IF (
    txt <> BLANK(), 
     "data&colon;image/svg+xml;utf8,<svg xmlns='http://www.w3.org/2000/svg' height='20' width='70'>""<text font-family = 'Segoe UI' x='50%' y='50%' font-size='15' fill='#404040' font-weight='" & FontWeight & "' dominant-baseline = 'middle' text-anchor = 'middle'>" & txt & "</text></svg>"
)

 In additon, remember to change the data category to Image URL:

Result for your reference:

Best regards,

Joyce

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[ldwf]

I tried your methodology, and although I don't get any syntax errors, the field is odd when I add it to the matrix.  See screenshot.  Values of 0 are blank, and non zero values show odd results

 

[Andy0407]

You need to apply the same logic, but with normal font for other values as well. Please refer the below dax. I am applying this on a dimension. Use the same logic to apply for your measurable field as well.

Measure =

VAR FontWeight ="bold"

var nf = "normal"

var txt = SELECTEDVALUE('Table'[State])

var bold = "data&colon;image/svg+xml;utf8,<svg xmlns='http://www.w3.org/2000/svg' height='20' width='70'>""<text font-family = 'Segoe UI' x='50%' y='50%' font-size='18' fill='#404040' font-weight='" & FontWeight & "' dominant-baseline = 'middle' text-anchor = 'middle'>" & txt & "</text></svg>"

var norm = "data&colon;image/svg+xml;utf8,<svg xmlns='http://www.w3.org/2000/svg' height='20' width='70'>""<text font-family = 'Segoe UI' x='50%' y='50%' font-size='17' fill='#404040' font-weight='" & nf & "' dominant-baseline = 'middle' text-anchor = 'middle'>" & txt & "</text></svg>"

return IF(SELECTEDVALUE('Table'[State])= "Total", bold, norm)

[Anonymous]

Hi @ldwf , 

Thank you for your feedback.

If possible, please upload your svg code or attach sample files without sensitive information for better troubleshooting.

[ldwf]

Here is the SVG Code.  For security reasons, I am prevented from uploading any files.

[Anonymous · Accepted solution]

Hi @ldwf ,

Please use standard data URI prefixes instead of &colon; html entity encoding.

And replace Blank with Not(ISBlank) to show a zero value.

Best regards,

Joyce

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Bibiano_Geraldo]

Hi,

The native matrix of power Bi dont support to bold values for only one column.

You can search alternative ways, maybe changing the font color for desired column or look for other Matrix in power bi visuals store.

[lbendlin]

Yes, you can do this with SVG code.  Give that a try.