Multiple set of data in a single table (help pls)

[Anonymous]

Hi All,

I have a situation where I have more than 3 data sets in a sigle table with multiple countries / entites options. Appreciate if you could advise how to move this forward.

Challenge: I want to show the activity available for each country entity (i.e. CN10, PK11 etc). However, due to the Yes/No data value set. It is currently not able to put into any visual chart. 

Please advise if I need to pivot this before uploading into powerbi, or do i need to reshape all basic data? 

[v-jiascu-msft]

Hi @Anonymous ,

Could you please mark the proper answers as solutions?

Best Regards,

[v-jiascu-msft]

Hi @Anonymous ,

What's the result you'd like to have? Mostly you will put the amount of "Yes" or "No" in a visual. You can count the values. It seems unpivoting the table is necessary.

Best Regards,

[Greg_Deckler]

I would unpivot your country columns and probably replace "Yes" with 1 and "No" with 0, although you could still leave them as text and use counts, etc.