Forum Discussion
samc_26
3 years agoHelper IV
Conditional formatting - problem with the 'if value = 0' horizontal arrow
Hi, I've managed to display a table in Power Bi which shows any positive figures (above 0) to show a green up arrow, negative values to show a red down arrow but for '0' values I want it to show an amber horizontal arrow but it either shows a red or green arrow instead. Can anyone tell me what I'm doing wrong please? Image to show my table and the rules I've used. Many thanks!
5 Replies
- PadycosmosSolution Sage
Hope this helps:
- samc_26Helper IV
Hi Padycosmos , thank you for your reply! I've tried this but I don't get the options for the 'less than' 0.0001 on the second column...
- PadycosmosSolution Sage
Sorry about that. Could you please try the following: