# How not display lines containing zeros in a Power table (dataset) **URL:** \ **Category:** Ignition\ **Created:** [September 2, 2020, 9:12pm UTC](https://forum.inductiveautomation.com/t/how-not-display-lines-containing-zeros-in-a-power-table-dataset/38331 "2020-09-02T21:12:06Z")\ **Posts on this page:** 1\ **Showing post:** 2
**Author:** ![jlandwerlen](https://avatars.discourse-cdn.com/v4/letter/j/bc8723/32.png) [@jlandwerlen](https://forum.inductiveautomation.com/u/jlandwerlen)\ **Post date:** [September 3, 2020, 2:15am UTC](https://forum.inductiveautomation.com/t/how-not-display-lines-containing-zeros-in-a-power-table-dataset/38331/2 "2020-09-03T02:15:13Z")
Some hints: > [@Filtering results of a dataset](http://forum.inductiveautomation.com/t/filtering-results-of-a-dataset/3807): > > Lets say I run this code to populate a table with battery voltages: [code]query = “SELECT displayname, devicename from devices” if event.propertyName in [“devices”, “refresh”]: table = event.source.getComponent(‘Table’) newData = [] header = [“Displayname”, “Identifier”, “Battery Voltage”] res = system.db.runQuery(query) tagPaths = [] for row in res: tagPath = row[1] tagPaths.append("%s/Volts"%tagPath) results = system.tag.getTagValues(tagPaths) idx = 0 for row in res: displayNa… > [@Named Query, Power table, Row color based off column value](http://forum.inductiveautomation.com/t/named-query-power-table-row-color-based-off-column-value/20779): > > This should be fairly easy however I am quite new at this, scoured the forms and much of what I’ve found is quite vague. I have a power table running a named query that updates every 5 min. I would like to change the row colors based on the value in column 8. The values in column 8 go up to 400. From 0-90 I would like the row to be red, from 90-120 the row yellow, from 120-400 green. I have tried various scripts in the configureCell to no avail. Can this be done by binding in the Backgroun… --- _[View the full topic](https://forum.inductiveautomation.com/t/how-not-display-lines-containing-zeros-in-a-power-table-dataset/38331)._