Conditional Formatting on Table Visual

[CHARLEA1]

Hi there, 
I'm having an issue with conditionally formatting my table visual on powerbi. I have made a dummy set image to describe the issue I'm having: 

Basically, I have conditionally formatted the first column based off of the value in the second (ie colour background orange if no. = 1). For some reason, it does not conditionally format the rows that are missing some or all of the data in the two data columns.

 
Important to note: When conditionally formatting, I believe I have the base the formatting off of the sum of the no. field (as there are no options to not summarise), but in the table visual for the no. column I have to format it to not summarize or else the 1 for example3 and example4 will disappear. 

When I delete data columns from my visual it formats correctly i.e.

Thanks in advance!
Ashling

[amitchandak]

@CHARLEA1 , This can work in table visual not in the matrix.

You can use rule based conditional formatting

If No is measure use [No] else use max(Table[No])

You can also create a measure

Switch([No] // or max(Table[No]) ,

1, "Orange", "White")

Use this measure in conditional formatting using field value option

[CHARLEA1]

Hi Amit, 
Yes I did use a table visual not matrix (perhaps you are confused by the image formatting, I made up the example on excel). 
I have done rule based and created a measure and done field based although it still doesn't seem to colour the rows that don't have data in the corresponding columns.

Thanks,

Ashling