Forum Discussion
LamdaLamda
Microsoft Employee
6 years agoConditional 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 sh...
LamdaLamda
Microsoft Employee
6 years agoHello - 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
Microsoft Employee
6 years agoenough info to make a suggestion?
- LamdaLamda6 years ago
Microsoft Employee
bump