how to get rid of blank slicers?

[aliffe]

why do i get double "USA" data there? 

• i tought it was because there is extra spaces in the "USA" but i tried to trim it and it doesn't resolve the problem
• it makes my slicers and chart have some blank data

[v-tangjie-msft]

Hi @aliffe 

Whether the advice given by suparnababu8   has solved your confusion, if the problem has been solved you can mark the reply for the standard answer to help the other members find it more quickly. If not, please point it out.

Best Regards,

Neeko Tang

[suparnababu8]

Hi @aliffe 

Check the relationship b/w your Sales and Geography tables. Make sure that 1 to * (one to many) relationship. I also faced the same problem bcz of many to many relationship. 

[ryan_mayu]

you can unselect the blank value in the visual filter

https://learn.microsoft.com/en-us/power-bi/create-reports/power-bi-report-add-filter?tabs=powerbi-de...

[danextian]

Hi @aliffe 

One of the USA probably has an invisible extra character in it. Try trimming it  in Power Query.

[aliffe]

i did trim it but still i have 2 "USA" and it make my chart and slicers have a blank data.

[danextian]

Which column did you trim? The one with 2 USAs. If trimming didn't work there are most likely other characters in there that trimming couldn't remove. If so, duplicate the query containing that column. Remove all other columns except for the one in question then remove duplicates. Inspect the actual values of USA then just replace it with the correct value. The actual value could be USA#(lf)  for line feed or #(cr) for carriage return

Alternatively, I would do a Text.Select([column], {"a".."z", "A".."Z"}) custom column.

[Irwan]

hello @aliffe 

visual filter should do the wonder if you dont mind using one.

Thank you.

[aliffe]

I can't do that bro, cause it still will be shown in the chart like this