Forum Discussion

srk_powerbi's avatar
srk_powerbi
Icon for Helper II rankHelper II
5 years ago
Solved

conditional formatting for table positive and negative numbers

hi, I am trying to apply conditional formatting for icons for a measure columnin table. it should show For positive values, green up arrow, for '0' value  yellow icon and for negative values red ico...
Need Help
  • v-jingzhang's avatar
    v-jingzhang
    5 years ago

    Hi srk_powerbi 

    You can add a measure in the model to help set conditional formatting. For example,

    Icon measure = 
SWITCH (
    TRUE (),
    [Difference] > 0, 1,
    [Difference] = 0, 0,
    [Difference] < 0, -1
)

    [Difference] is the measure in the table which this icon formatting should be based on. Then set it up like below.

    Result:

     

    Kindly let me know if this helps.
    Community Support Team _ Jing
    If this post helps, please Accept it as the solution to help other members find it.

srk_powerbi's avatar
srk_powerbi
Icon for Helper II rankHelper II
5 years ago

that did not work..

  • v-jingzhang's avatar
    v-jingzhang
    Icon for Community Support rankCommunity Support
    5 years ago

    Hi srk_powerbi 

    You can add a measure in the model to help set conditional formatting. For example,

    Icon measure = 
SWITCH (
    TRUE (),
    [Difference] > 0, 1,
    [Difference] = 0, 0,
    [Difference] < 0, -1
)

    [Difference] is the measure in the table which this icon formatting should be based on. Then set it up like below.

    Result:

     

    Kindly let me know if this helps.
    Community Support Team _ Jing
    If this post helps, please Accept it as the solution to help other members find it.

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Can you do this with percentages. The numbers did not work. Thanks!