Failed when using the filter_query in style_data_conditional in dashtable

Trying to use the filter_query in style_data_conditional to styling certain row in the dashtable. However, receive the error message.

Referring to the Highlighting Text that Equals a Value

Error message:

DataTable filtering syntax is invalid for query: {column1} = “Grand Total”

(This error originated from the built-in JavaScript code that runs Dash apps. Click to see the full stack trace or open your browser’s console.)


                         'if': {
                                'filter_query': '{column1} = "Grand Total" ',
                                # 'column_id': 'column1'
                            },'backgroundColor': 'tomato',
                               'color': 'white'

Anyone know how to solve it or any advise on how to styling the row in dashtable?


And I would like to ask if you have double-checked the col id?


Thanks for your helps.

Found out is the data issue. Have to remove the space between the word.

“Grand Total” → will show error message
“Grand_Total” → successful