Forum Discussion
Icons within Conditional Formatting.
Hi Jeff2Jets
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
Hi Jeff2Jets
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
Phil,
Thanks for your reply. However, I found another way to do this as a color key.