The Recipes challenge

[RRSSDW]

Hi community, have a data-visualization issue that I do not know hot to afford. It is a quite common data visualization challenge when we deal with recipes or similar type of data. Have quite a lot (let me say cooking recipes) using in total say 200 ingredients. I am looking for a filter where the user selects an ingredient (eggs for instance) and it filter all FULL RECIPES containing eggs. 

In terms of data into a relational database, this is a filed per every ingredient (200 fields). If a recipe contains the ingredient, then all records of that recipe are marked, as pictured here. I can easily implement it by a SQL data-procedure, but then the problem is on the visual side. The visual would have 200 slicers, in addition to the current onces and you may agree with me that it is not the proper solution per end user interaction perspective. How would you afford it or how did you do it? 

[RRSSDW]

Thanks. I have done a quick test and I see that it can be the solution. By the unpivot of above pictured structure, every Cake & Ingredients is repeated n times as the number of Ingredients on the left side of the table. Then the value come in. A logical column is needed. I will implement in the real dataset. I expect 8 million rows for this new table that will be added to the data model. I cross fingers on performance. Again, thank for the solution. It did not come to my mind 

[Ashish_Mathur]

You are welcome.

[Ashish_Mathur · Accepted solution]

Hi,

In the Query Editor, select the first 2 columns, right click and select "Unpivot Other columns".  Create a slicer from the Attribute column.