topic Re: Custom Icons within Dax Measure returning Text. in DAX Commands and Tips

Custom Icons within Dax Measure returning Text.

Michal_Plawski — Tue, 09 Apr 2024 10:17:08 GMT

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.

Re: Custom Icons within Dax Measure returning Text.

Anonymous — Wed, 10 Apr 2024 07:50:46 GMT

Hi Michal_Plawski ,

This is the related document, you can view this content:

Tips on displaying icons based on field values in ... - Microsoft Fabric Community

End-to-End Example for Adding Icons to Your Power ... - Microsoft Fabric Community

How to use custom icons in DAX - Microsoft Fabric Community

Best Regards,

Liu Yang

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

Re: Custom Icons within Dax Measure returning Text.

Michal_Plawski — Wed, 10 Apr 2024 09:32:00 GMT

Hi Anonymous,

Unfortunatelly, this is a way to use custom icons as conditional formatting, and I was able to do that already.
I am looking for a way, to use them as part of a text measure, where I could use multiple icons interweaved with text in a single table cell, or in a card visual.
I will mention that using char(s) is not the answer I am looking for either, as I am looking for flexibility in terms of the icons I am able to use.

Best regards,
Mike

Re: Custom Icons within Dax Measure returning Text.

johnbasha33 — Wed, 10 Apr 2024 11:00:53 GMT

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 !!