country wise Yes/No

RMtechm — Mon, 19 Dec 2022 10:57:36 GMT

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.

Re: country wise Yes/No

Anonymous — Tue, 20 Dec 2022 07:43:59 GMT

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

Re: country wise Yes/No

RMtechm — Wed, 21 Dec 2022 09:45:25 GMT

Thanks for solution.

topic country wise Yes/No in Developer

country wise Yes/No

Re: country wise Yes/No

Re: country wise Yes/No