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...
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