Multiple country list with only US country data want, how to do ?

[Ayyappa5678]

Hi Team,
I new to power bi. small doubt.
In below snapshot of dest_country column having list of multiple countries & null info, But I want only US country data.

How to do with that in seperate column, kindly please suggest with snapshots.

[Anonymous]

Hi @Ayyappa5678 ,

Please go to Power Query Editor, just only check "US" and click OK.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[KeyurPatel14]

Create a custom column using below formula:

if [Countries] = US then US

else ""

[Ayyappa5678]

This will not work, Kindly Please suggest with correct formula

[AlB]

@Ayyappa5678 

Just filter for US. In the step in the snapshot that you show in your first post, deselect all and then select US

Please accept the solution when done and consider giving a thumbs up if posts are helpful.  Contact me privately for support with any larger-scale BI needs, tutoring, etc.

[Ayyappa5678]

Hi AIB, 
Thanks for your response,
Below is the snapshot, In that countries column have multiple countries data, But I want only US country data as like below snapshot. and remaing countries like IND,SA,AUS not required, even blank data also not required.
Hope you understand now, kindly respond with my query!

[AlB]

Hi @Ayyappa5678 

What do you mean in a separate column? Please show a sample of your data and the expected result, in text-tabular format so that the contents can be copied

Please accept the solution when done and consider giving a thumbs up if posts are helpful.  Contact me privately for support with any larger-scale BI needs, tutoring, etc.