Forum Discussion
Conditional Formatting on ROWS in Matrix Table (not values)
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.
3 Replies
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.
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.
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
