Forum Discussion

StephenF's avatar
StephenF
Responsive Resident
2 years ago

Dynamic font size in a table visuals text values

I have a table that displays text strings in the body, ie in the "values". These values are typical single or pairs of words, "dance", "Crime", " "New Age", "Period Drama"

 

Sometimes the strings are longer words, and you cant see the whole word.

 

Rather than use wordwrap, I want to make the font dynamic so say a 3 letter word in a cell would appear larger in font size then a 8 letter word. Can font size in a table be made dynamic?

 

 

Need Help

2 Replies

  • TomMartens's avatar
    TomMartens
    Super User
    2 years ago

    Hey StephenF ,

     

    unfortunately the answer is - No!
    The font size of values of the table/matrix visual are not dynamic.

     

    Regards,

    Tom

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi TomMartens ,thanks for the quick reply, I'll add further.

    Hi StephenF ,

    Perhaps you can use the Html visual object.

    The Table data is shown below:

    1.Use the following DAX expression to create a table

     

     

    Table = ADDCOLUMNS(SUMMARIZE('Sales_Table','Sales_Table'[Product],"Total",SUM(Sales_Table[Amount])),"Length",LEN([Product]))

     

     

     

     

    2.Use the following DAX expression to create a column in 'Table'

     

     

    Column = 
VAR _a = SWITCH(TRUE(),
[Length] <=5,"5",
[Length] >5 && [Length] <=14,"3",
[Length] >14,"1"
)
VAR _average = CALCULATE(AVERAGE('Table'[Total]),ALL('Table'))
VAR _b = SWITCH(TRUE(),
[Total] < _average,"red",
"black")
RETURN "<tr>" & "<td style= width:150px;><font size=" & _a & ">" & [Product] & "</font></td>" & "<td align=left><font size = 3>" & "Sales: </font>" &
"<font color=" & _b & ">"  &
[Total] & "</font></td>" & "</tr>"

     

     

    3.Use the following DAX expression to create a measure

     

    Measure = 
VAR _a = CONCATENATEX('Table',[Column])
VAR _b = SUM('Sales_Table'[Amount])
RETURN "<table >" &
 "<tr>" & "<td><font size = 6>Product</font></td>" & "<td><font size = 6>Sum of Amount</font></td>" & "</tr>" &
 "<td colspan = 2><hr style = border-color:blue;></td>" &
 _a &
 "<td colspan = 2><hr style = border-color:blue;></td>" &
 "<tr>" & "<td><font size = 6>Total</font></td>" & "<td align=right><font size = 6>" & _b & " </font></td>" & "</tr>" &
 "</table>"

     

     

    4.Final output