AdWords is now Google Ads. Our new name reflects the full range of advertising options we offer across Search, Display, YouTube, and more. Learn more

Data Studio
3K members online now
3K members online now
Ask questions about Data Studio
Guide Me
star_border
Reply

DataStudio filter not working if values contain comma

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

Hi,

 

I am trying to use a filter with city values. These values also have the name of the state in an abbreviated form separated by a comma. For e.g. "Austin, TX". When I select this value in my filter, all my charts do not display any data. If I change the values by removing the comma, for e.g. "Austin TX", the chart starts working fine. Please advise if there is a workaround.

 

Thank You.

 

 

DataStudio filter not working if values contain comma

Participant ✭ ☆ ☆
# 2
Participant ✭ ☆ ☆

DataStudio filter not working if values contain comma

Visitor ✭ ✭ ✭
# 3
Visitor ✭ ✭ ✭

Thank you. Do we have any way to make the filter work with the commas? Regex Replace would simply remove the commas from the filter values.

DataStudio filter not working if values contain comma

Participant ✭ ☆ ☆
# 4
Participant ✭ ☆ ☆

To my knowledge not at this time.