Forum Discussion
Microsoft EmployeeConditional formatting of Measure in a Table
Hi All,
Is it possible to conditionally format a measure inside a table visual? I have pulled 5 metrics into my table visual, all are measures, and am looking to format my last two columns to show Red if negative and Green if positive. I have worked the logic to where I think it should be but nothing ever happens. I use the rule option and put if greater = to 0 and less than (maximum) and the 2nd rule just says less than 0 turn a different color. The two columns are a % though - not sure if that helps. Is it possible to do this with a measure inside of a table visual?
Thanks!
7 Replies
- Greg_Deckler
Community Champion
Should be possible, would need to see some screen shots of how you have setup conditional formatting and maybe some sample data to recreate. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
LamdaLamdaHello - the formatting link above seems outdated - I don't see the ability in rules to specify if its a number, %, etc.
As per a screenshot - here is the filter i'm trying to apply:
My field in the table i'm trying to change is Net Revenue. It is a percentage - currently the field shows 156%. So i'm trying to simply say if the % is greater than or = to 0 - make the background, or even font color I don't care, set to Green and if below zero - as my other column i'd like to use the same formatting on is -56% - set it to Red. So a really simple condition that says if is zero % or above Green, negative then Red.
When I click OK it goes back to the table and nothing happens. Any thoughts?
- LamdaLamda
enough info to make a suggestion?
