country wise Yes/No

[RMtechm]

Hi Team,

as attached example i want to show in which country that perticular application is used insted of count want to see if it is used then "Yes" or else "No".

Thanks in advance.

[RMtechm]

Thanks for solution.

[v-yiruan-msft · Accepted solution]

Hi @RMtechm ,

I created a sample pbix file(see attachment) for you, please check whether that is what you want.

1. Handle with it in Power Query Editor just as below screenshot

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45W8i8tycnPz1bSUTKCYkMkDEGGllAaIhyrE63kGuHs6qPglpmTiqLSCFWfKZwJ1hSUmptSiRDChsxhal2SUhPLUotwqUMz2TexuDizAr/RpjDF/kWJyWB3G2FVZ4xqtGtAgGcEfpNNYGqLU4vKMpNTFfzyy1ENQkWGSMY7+/jiUobskFgA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [#"ERP/App" = _t, Benin = _t, #"Cote d'lvoire" = _t, Eswatini = _t, Ghana = _t, Group = _t, #"Group RAFM" = _t, Liberia = _t, Nigeria = _t, Rwanda = _t, SA = _t, Zambia = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"ERP/App", type text}, {"Benin", Int64.Type}, {"Cote d'lvoire", Int64.Type}, {"Eswatini", Int64.Type}, {"Ghana", Int64.Type}, {"Group", Int64.Type}, {"Group RAFM", Int64.Type}, {"Liberia", Int64.Type}, {"Nigeria", Int64.Type}, {"Rwanda", Int64.Type}, {"SA", Int64.Type}, {"Zambia", Int64.Type}}),
    #"Replaced Value" = Table.ReplaceValue(#"Changed Type",null,0,Replacer.ReplaceValue,{"Benin", "Cote d'lvoire", "Eswatini", "Ghana", "Group", "Group RAFM", "Liberia", "Nigeria", "Rwanda", "SA", "Zambia"}),
    #"Unpivoted Other Columns" = Table.UnpivotOtherColumns(#"Replaced Value", {"ERP/App"}, "Attribute", "Value"),
    #"Added Custom" = Table.AddColumn(#"Unpivoted Other Columns", "IsUsed", each if [Value]<>0 then "Yes" else "No"),
    #"Removed Columns" = Table.RemoveColumns(#"Added Custom",{"Value"})
in
    #"Removed Columns"

2. Create a matrix visual

If the above one can't help you get the desired result, please provide some sample data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It would be helpful to find out the solution. You can refer the following links to share the required info:

How to provide sample data in the Power BI Forum

How to Get Your Question Answered Quickly

And it is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community.

How to upload PBI in Community

Best Regards