Custom Icons within Dax Measure returning Text.
Hi, I am working on a report for accessing information about uploaded documents (via MS Forms). I created a measure, that depending on the row level, will either give us the name of the file with a conditional icon (they are added to the json theme) that reflects that file's extension, or a Sharepoint Icon, and a count of different files + Count of file types. This is the measure: Document Title* = VAR _List = CALCULATE(CONCATENATEX(DISTINCT('fact_OfficeForms Table'[Extension]), '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 In the case where there are multiple files in the row level context, instead of simply listing the file type extensions I would like to list the icons, like this: But I don't know if it is possible to use Icons that way, in text (not in conditional formatting). Any help would be much appreciated! Best regards, Mike.
