Conditional Formatting in Matrix

[Syndicate_Admin]

Hello everyone

You could help me create a conditional format to shade the cell that contains the maximum and minimum value per row of the following array, as shown in the image below.

In red are the maximum values per fi

[amitchandak]

@Syndicate_Admin , Create measure like

Measure =

var _min = calculate(minx(values(Table[Column Field]), [Measure]), removefilters(Table[Column Field]))

var _max = calculate(maxx(values(Table[Column Field]), [Measure]), removefilters(Table[Column Field]))

return

Switch( True(),

[Measure] = _max, "Green",

[Measure] = _min, "Red",

"white"

)

Use this measure in conditional formatting using field value option

Learn Power BI Advance - PowerBI Abstract Thesis:
How to do conditional formatting by measure and apply it on pie?
https://www.youtube.com/watch?v=RqBb5eBf_I4&list=PLPaNVDMhUXGYo50Ajmr4SgSV9HIQLxc8L
https://community.powerbi.com/t5/Community-Blog/Power-BI-Conditional-formatting-the-Pie-Visual/ba-p/...
https://amitchandak.medium.com/power-bi-where-is-the-conditional-formatting-option-in-new-format-pan...