Forum Discussion
Display value as icon
admin_xlsior
You can create a Measure and use under option Field Value in the Conditional Formatting window:Flag = VAR __Value = SELECTEDVALUE(Table1[% Value] ) return SWITCH( TRUE(), __Value > 1 , "GREEN", __Value = 0 , "YELLOW", __Value < 1 , "RED" )________________________
If my answer was helpful, please consider Accept it as the solution to help the other members find it
Click on the Thumbs-Up icon if you like this reply 🙂
admin_xlsior , You can create a color measure or icon measures.
For Icon Formatting refer
https://exceleratorbi.com.au/conditional-formatting-using-icons-in-power-bi/
https://community.powerbi.com/t5/Desktop/FORMAT-icon-set-for-use-in-a-data-card/td-p/811692
admin_xlsior , You can create a color measure or icon measures.
For Icon Formatting refer
https://exceleratorbi.com.au/conditional-formatting-using-icons-in-power-bi/
https://community.powerbi.com/t5/Desktop/FORMAT-icon-set-for-use-in-a-data-card/td-p/811692
Hi amitchandak
Yes, that's where I confused about the setting whereby it doesn't let me to have only 1 condition. it needs 2 like "If value greater...and less..."
But I just saw your link, from Matt Allington, it is mentioned about the use of Maximum and Minimum, which I just tried it immedlietly. But it give me error, also the Ok button disabled.
Thanks,
Hi all,
Managed to do this. Turned out I need use Numbers instead Percent
Many thanks for all the help.
