Conditional Formatting on ROWS in Matrix Table (not values)

[nataszba]

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.

[P_d2023]

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

[nataszba]

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.

[FreemanZ]

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.