Forum Discussion
conditional formatting
First you need to create 2 measures. One used in the matrix visual and the other that will be used in conditional formatting
Flag measure = if(isblank('project'[daycount]), "N", "Y")
Flag measure Conditional = if(isblank('project'[daycount]), "#CCCCCC", "#FF0010")
When you create the matrix visual, select the first measure from conditional formatting section.
Select 'Flag Measure' in conditional formatting section --> and on the pop up window --> select Format by (field Value) --> select the second measure (with the colours)
Image below
ashik1992 , Create a color measure like this and use that is conditional formatting with "Field value" Option
color measure =if(isblank([measure], "grey", "red") // where measure is measure you used values
https://radacad.com/dax-and-conditional-formatting-better-together-find-the-biggest-and-smallest-numbers-in-the-column
https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting#color-by-color-values
what about indicating 'Y" and N ?