Forum Discussion
Solved
The Recipes challenge
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 (...
Hi,
In the Query Editor, select the first 2 columns, right click and select "Unpivot Other columns". Create a slicer from the Attribute column.
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
You are welcome.