Forum Discussion
Word cloud choosing different fields
Hi. I have this table and I'm trying to create a way that the user can choose the specific fields to look at the results in the soundcloud. Here's a sample of the data and what I'm trying to achieve...
Hi Anonymous ,
According to your description, I think you should change the data structure. Go to Power Query, select the columns and click "Unpivot".
The table changed to :
Then create a matrix like below, put the Word column in a slicer, it will work fine.
I attach my sample below for your reference.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best regards,
Community Support Team_yanjiang
Thanks very much for your help on this. It worked as I hoped.