Forum Discussion

pedrogarcia's avatar
pedrogarcia
New Member
3 years ago
Solved

Highlight the max value in a chart /visual

please I need your help I am trying to highlight the max value of the sales amount by using the code below but it doesn't work  any ideas. Max sales Amount = VAR Maxsales= MAXX( ALL(Sales[Ch...
Need Help
  • Chew_WenJie's avatar
    Chew_WenJie
    3 years ago

    Hello, you may follow the dax measure below and put into the conditional formatting for the color MAX bar.

     

    IF(
          CALCULATE(MAX('Sales Amount'),ALL('Channel')) = 'Sales Amount',
          "Red",
          "Green"
    )
    Right click the sales at the values then choose Conditional Formatting and Font Color

    After that choose Field Value and choose the Measure you just now created. It should show the color now.

    Hope this can help you.

Chew_WenJie's avatar
Chew_WenJie
Resolver III
3 years ago

Hello, you may follow the dax measure below and put into the conditional formatting for the color MAX bar.

 

IF(
      CALCULATE(MAX('Sales Amount'),ALL('Channel')) = 'Sales Amount',
      "Red",
      "Green"
)
Right click the sales at the values then choose Conditional Formatting and Font Color

After that choose Field Value and choose the Measure you just now created. It should show the color now.

Hope this can help you.