Use icons in a measure

[Roym]

In my report I use the below formatting on a table to show the different icons in front of the name. This works perfecty but now I want to add a legend below the table that describes what the different collors mean. To have exactly the same colors I would like to use these specific icons. Is there a way to create a new measure or something that uses these exact icons? I found this link that shows the name of the different icons but not sure on how to add this to a measure? https://community.fabric.microsoft.com/t5/Desktop/What-are-the-icon-IDs-In-July-update/m-p/752075#M3...

[Anonymous · Accepted solution]

Hi @Roym 

To use these specific icons, I think of a small trick. You can still use a table or a matrix visual and set the icon conditional formatting with the same icons in it. Then modify all grid lines to color white (or the same color as report's background) and width 0. This will make grid lines invisible. Modify all column and row header text to have the same color as backgroud's too. Then you will have a similar result as below. Use it as a legend below your data table visual. 

In above picture, the left one is created with a table visual and the right one is a matrix visual. You can also pick any value in it to interact with other visuals on the same page.

Otherwise you may have to create a measure using SVG or Unicode to have these icons and display it in a card visual or some other visuals. Tips on displaying icons based on field values in ... - Microsoft Fabric Community

Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!

[Roym]

Nice, didn't think about doing it this way, thanks!! This will work perfectly for me!