Forum Discussion
conditional formatting
Hello Folks,
Im an beginner here . Need one help .
I have a matrix like this. in the row ,there is project details and states. in column there is day data. in value it is count of projects in respective sates.
I want to do conditional formating .
condition is ,if there is blank cell,make the color grey and it is shown as "N" and if cell is not blank it should display in red color with "Y". Please help me to achieve it
| Project details1 | day1 | day2 | day3 |
| Developemnt | 12 | 14 | |
| testing | 1513 | 13 | |
| ready | 12 | ||
| Project details2 | |||
| Developemnt | 3 | 5 | 7 |
| testing | 8 | ||
| ready | 45 |
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
12 Replies
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-valueswhat about indicating 'Y" and N ?
ashik1992 , Where you want to do that, You can have a measure and use that in the matrix
Flag measure =if(isblank([measure], "Y", "N")
