Forum Discussion
Icons within Conditional Formatting.
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.
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
2 Replies
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.
