Forum Discussion
Conditional formatting not working for single row .
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:
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:
Best Regards,
Giotto Zhi
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
Hi Anonymous
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
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
Anonymous
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"
)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