Forum Discussion

samc_26's avatar
samc_26
Helper IV
3 years ago

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

    • samc_26's avatar
      samc_26
      Helper 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...

      • Padycosmos's avatar
        Padycosmos
        Solution Sage

        Sorry about that. Could you please try the following: