Forum Discussion
Conditional formatting not working for single row .
- 6 years ago
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,
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
- Shahin6 years agoFrequent Visitor
Thanks v-gizhi-msft so much . it worked. it is even woked with rules.