topic Conditional Formatting on ROWS in Matrix Table (not values) in DAX Commands and Tips

Conditional Formatting on ROWS in Matrix Table (not values)

nataszba — Fri, 07 Apr 2023 08:19:30 GMT

Hello,

I am trying to achieve the same effects as in Excel Pivot - I have a matrix table in PowerBI where values are only count of documents, and other information (name, department, end date etc.) is stored in rows.

I need a way to format End date - everything in the past is red, everything in the future green. I tried to look for similiar issue as mine, however all of the solution are based on conditional formatting option - but I think if you store data in rows, no conditional formatting is possible. Below is a sample of data:

Manager Name (row)	End date of contract (row)	Documents (values - count)
xxxxxxxxx	31.01.2023	2
yyyyyyyy	10.05.2023	3

Is there any way to achieve it? In Excel Pivot you just simply insert a conditional formatting on any data point you want.

Re: Conditional Formatting on ROWS in Matrix Table (not values)

FreemanZ — Fri, 07 Apr 2023 08:43:56 GMT

you are right. it is applicable only on value fields.

try to provide some sample data and let us see if it could be converted to a measure to feed as a value field.

Re: Conditional Formatting on ROWS in Matrix Table (not values)

nataszba — Sat, 08 Apr 2023 06:28:07 GMT

Thanks Freezman for a reply, I will try to find similiar data or recreate it, since I work with restricted client information and cannot share it.

Re: Conditional Formatting on ROWS in Matrix Table (not values)

P_d2023 — Sat, 08 Apr 2023 12:02:07 GMT

one of the way to get round this is to create a new column.

in the table where the date feild to be analysed is held, create a custom column using the below logic

then when you drop this into a column in the table

set as min if this lives in a fact table

you can then add a conditional format to column i have gone for an icon.

choose how you want it to look like

then this is what the column looks like in the table

hope this helps