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 measurem...
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