topic Re: Conditional Formatting per row on Matrix in DAX Commands and Tips

Conditional Formatting per row on Matrix

Anonymous — Sat, 23 Apr 2022 16:49:21 GMT

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!

Re: Conditional Formatting per row on Matrix

speedramps — Sat, 23 Apr 2022 17:19:00 GMT

Hi jostho99

Please 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

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.

Create a dax measure like this

KPI Colour =

VAR mytarget = SELECTEDVALUE(Facts[Target])

RETURN

IF(SUM(Facts[Value])> mytarget, "Red","Green")

Then in conditioinal formating select
Format Style = Field Value

What field should we base this on = KPI Colour

Re: Conditional Formatting per row on Matrix

Thamizh_hfhs — Thu, 23 Feb 2023 19:17:14 GMT

Im assuming the Facts[Value] is a column in the table. What is the Facts[Value] is a measure? How to change the formula?

I have a similar situtaion where I have a measure "TurnOverRate" and I used the same formula you suggested but my measure is not detectable.