Conditional formatting not working for single row .

[Shahin]

Hi Community,

Does any body know why the conditional formating not working when you have only one row in your table?  Appricate your responce.

Regards,

Shahin

[v-gizhi-msft · Accepted solution]

Hi,

According to your description, I think that any table which doesn't have a grouping displayed as a single row doesn't support conditional formatting.

Reference:

https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting#considerations-and-li...

And I have a workaround for your problem, so I create a table to test:

please take following steps:

1)Create a measure to minus [Actual] and Budget:

Measure = SUM('Table'[Actual])-SUM('Table'[Budget])

2)Create a measure to define font format and apply it to above measure:

Format = SWITCH(true,[Measure]>0,"#FF0000",[Measure]<0,"#008000")

And it shows:

3)Add a column and change it not summarize:

When you remove [Department], it shows:

if you do not want to display the blank column, you can turn off ‘Word wrap’ function in visual format/column headers:

And it shows:

Here is my test pbix file:

pbix 

Best Regards,

Giotto Zhi

[Shahin]

Thanks @v-gizhi-msft  so much . it worked. it is even woked with rules.

[AiolosZhao]

Hi @Shahin ,

Could you please show your sample data or screenshaot or measure of your report?

Because it always works in my report.

Aiolos Zhao

[Shahin]

Hi @AiolosZhao 

On the left I have my measure against department which works pefectly fine but as soon as I remove the department from the table (table on the right) the conditional fromating stops working.

Thanks 

[AiolosZhao]

Hi @Shahin ,

Are you using a Field value to do the conditional formatting?

If yes, could you please share your Field value measure?

Aiolos Zhao

[Shahin]

@AiolosZhao  

No, I m using the rules . I tried the Filed Value and got the same result. 

SWITCH(TRUE()

,[F A Lab Rev]- [F B Lab Rev] < 0,"#FF0000"
,[F A Lab Rev]- [F B Lab Rev] > 0 ,"#008000"
)

[AiolosZhao]

@Shahin ,

I assume the [F A Lab Rev] and [F B Lab Rev] are actual and budget, and it works for the first 2 rows.

It also doesn't work for the third row, but the "#008000" is green color I think, but it's black in your left table.

Aiolos Zhao