Forum Discussion
Custom Icons within Dax Measure returning Text.
Michal_Plawski
Here's how you can modify your measure to include icons alongside the file extensions:
Document Title* =
VAR _List = CONCATENATEX(
DISTINCT('fact_OfficeForms Table'[Extension]),
"<img src='" &
SWITCH(
'fact_OfficeForms Table'[Extension],
"pdf", "path_to_pdf_icon",
"docx", "path_to_docx_icon",
"xlsx", "path_to_xlsx_icon",
"path_to_default_icon"
)
& "' title='" & 'fact_OfficeForms Table'[Extension] & "'/>",
", "
)
VAR _FileTypeCount = DISTINCTCOUNTNOBLANK('fact_OfficeForms Table'[Extension])
VAR _Result =
IF(
HASONEVALUE('fact_OfficeForms Table'[ID]),
SELECTEDVALUE('fact_OfficeForms Table'[Document Title]),
IF(
COUNT('fact_OfficeForms Table'[ID]) = 0,
BLANK(),
DISTINCTCOUNTNOBLANK('fact_OfficeForms Table'[ID]) & " documents uploaded. " & _FileTypeCount & " file type(s) : " & _List
)
)
RETURN
_Result
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!