Icons within Conditional Formatting.

[Jeff2Jets]

I am using 'Conditional Formatting' icons for a column in a page that has a Table. To mitigate confusion, I would like to display a key for the possible icons and their meanings. In the example below, I would like to have a key as to what the red diamond means.

[PhilipTreacy · Accepted solution]

Hi @Jeff2Jets 

Download example PBIX file

You could create a table that holds numeric values that you can use to represent the icons.  You've got 1 icon in your example but I'm using 3, it's the same process.

For each numeric value, there's an associated description for what that icon means.

Note that these numeric values don't need any kind of relationship to your real data.

You can now add a table visual and add a conditional formatting rule to show the icons alongside the numeric values

Apply a custom formatting string  ;;; to the column which hides the numbers, then add the text description column,

further reading on custom formatting strings in Power BI

Regards

Phil

[Jeff2Jets]

Phil,

Thanks for your reply. However, I found another way to do this as a color key.