Forum Discussion
Matrix Row Conditional Formatting
Hi ml0911 ,
Apologies for asking again but there must be something in your model that is impacting the relationships or the calculations.
On a previous post you refer:"I just removed a blank row from this table and now it allowing a "one to many" relationship, however this has not fixed the issue with the cells not highlighting."
If now you have a one to many relationship using the values from the one side and making the format has reference you should get the colors on all the rows even for blank values because the context is now the dimension table.
Hi ml0911 ,
The issue occurs because the conditional formatting measure uses SELECTEDVALUE(), which can return BLANK and prevent coloring in some cells. Switching to MAX() in your color measure will ensure consistent formatting across the row, including for cells with 0.
RowColor =
VAR Dept =
MAX('Group Names'[Simple Group Names])
RETURN
SWITCH(
TRUE(),
Dept = "DPD", "#D9E1F2",
Dept = "UPD", "#E2EFDA",
Dept = "TT", "#FFF2CC",
"#FFFFFF"
)Then keep your conditional formatting set to Format by Field value and use this RowColor measure. This approach ensures the color is applied consistently across all cells in the row, including those displaying 0.
This did not solve the problem. The same exact thing is happening, where blank (which are forced 0 in my file) cells are not being highlighted. In the sample file you provided, the entire row (including blank cells) is not highlighted, which is what I'm asking for.
Hi ml0911 ,
I didn’t end up changing the measure or logic, instead, switching the visual from a Table to a Matrix resolved the issue, this works because conditional formatting in Power BI is applied at the value level , and in my previous setup some cells were effectively evaluated as blanks rather than actual values, so formatting wasn’t applied, but with the Matrix visual the evaluation context changed and those values were treated correctly, allowing the formatting to apply consistently even for 0s.
Please look at the photos in my post. I am already using a matrix not a table. This changes nothing
Hi ml0911 ,
The issue occurs because the conditional formatting measure uses SELECTEDVALUE(), which can return BLANK and prevent coloring in some cells. Switching to MAX() in your color measure will ensure consistent formatting across the row, including for cells with 0.
RowColor =
VAR Dept =
MAX('Group Names'[Simple Group Names])
RETURN
SWITCH(
TRUE(),
Dept = "DPD", "#D9E1F2",
Dept = "UPD", "#E2EFDA",
Dept = "TT", "#FFF2CC",
"#FFFFFF"
)Then keep your conditional formatting set to Format by Field value and use this RowColor measure. This approach ensures the color is applied consistently across all cells in the row, including those displaying 0.
I copy and pasted this exact formula and it still is not highlighting 0 values.
