Forum Discussion
Matrix - Conditional formatting by column
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
1 Reply
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
