Matrix - Conditional formatting by column

[Anonymous]

Hello people,

How do I apply conditional formatting to a matrix per column?

I would like to highlight the highest value of each column in the matrix:

These are the columns and measurements that I use:

column FORMA DE PAGAMENTO --> TABLE DM_PAGAMENTOS

column UF --> TABLE DM_ESTABELECIMENTO

measure  Lucro = SUM(FT_Pedido[Lucro_por_Produto])

The relationship is like this:

DM_PAGAMENTOS   1 ----- *   FT_Pedido   * -----  1    DM_ESTABELECIMENTO

[amitchandak]

@Anonymous , Create a measure like

if(max(FT_Pedido[Lucro_por_Produto]) =calculate(max(FT_Pedido[Lucro_por_Produto]),allexcept(FT_Pedido,FT_Pedido[FORMA DE PAGAMENTO ])) , "green","white")

and in conditional formatting use Field option and this measure

refer steps:https://radacad.com/dax-and-conditional-formatting-better-together-find-the-biggest-and-smallest-numbers-in-the-column
https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting#color-by-color-values