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.
I created a separate table for the drop down on the left, but I can't seem to progress any further. I basically want to be able to give the user the ability to choose a different cloud depending on the field that's chosen.
Can anyone assist in helping me find a solution ?
Thank you.
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
2 Replies
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