To many Columns

[CON3TROL]

Hello to all, 

i have a question. I want so create a visualization of an Excel-sheet. The Problem is, that the sheet have many columns. 

The example: 

A Bakery with many Bakery products. 

We have on the column A the ingredients. 

On the other 40 columns we have different Bakery products. At each bakery product it is written whether the bakery product contains the ingredients, with "yes", "no" and "ifyouwant".  How i can do that? And how i can filter by "yes" or "no" or "ifyouwant". 

I need support please. 

Thank you.

[v-yueyunzh-msft · Accepted solution]

Hi, @CON3TROL 

According to your description, the table structure is like this in mu thought:

If I'm right, then you just need to convert this table in Power Qeury Editor and turn this table into a table structure that can be analyzed to meet your needs.
In Power Query Editor , we can select the [ingredients] column and then click "Unpivot Other Columns":

Then we can get this table now :

Now we can apply the data to Desktop to analyze or filter your data.

Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

Best Regards,

Aniya Zhang

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