Conditional Formatting per row on Matrix

Question

Hi, I have a KPI dashboard to make and was wondering if there was a way to have conditional formating per row? Each metric will have different targets and I am trying compare each target to the different results per date. Some metrics have more complex statements where it will have different targets per location as well. I have attached a picture of some dummy data that shows what I am trying to portray. Thanks!

speedramps · Accepted Answer

Hi jostho99Please consider this solution and remember I am an unpaid Power BI volunteer, so click the thumbs up button if you like me helping you and the solved button if I fix your problem.Click here for an example solution&nbsp;&nbsp;This example has the targets in table but you could hard code them in a switch statement.A table is better because the users can edit the targets without a PBI developer changing DAX.&nbsp;Create a dax measure like thisKPI Colour = VAR mytarget = SELECTEDVALUE(Facts[Target])RETURNIF(SUM(Facts[Value])&gt; mytarget, "Red","Green")&nbsp;Then in conditioinal formating selectFormat Style = Field ValueWhat field should we base this on = KPI Colour&nbsp;

Forum Discussion

Conditional Formatting per row on Matrix

2 Replies

Related content

Matrix Row Conditional Formatting

Conditional Formatting using DAX

Conditional Formatting with Matrix Table

Conditional Formatting

Conditional Formatting