Forum Discussion

quyenduong's avatar
quyenduong
Helper II
3 years ago
Solved

How to create multiple word clouds based on year?

Hi everyone,

 

I have a data with two columns: one is datetime and one is the text like this (just illustrative, the actual data is much longer):

 

I would like to create 4 different word clouds from the name column by their created year (from 2019 to 2022) (see screenshot below). I read some questions on the community and could not find the way. Thank you so much for answering!

 

 

Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi quyenduong ,

    Please according the year to create new table then create the WordCloud visual with the new table fields, This is the only way I can think of at the moment.

    Table =
CALCULATETABLE (
    VALUES ( 'Table'[Name] ),
    FILTER ( ALL ( 'Table' ), YEAR ( 'Table'[Created_At] ) = 2021 )
)

    Thanks for your efforts & time in advance.

     

    Best regards,
    Community Support Team_ Binbin Yu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi quyenduong ,

    Please according the year to create new table then create the WordCloud visual with the new table fields, This is the only way I can think of at the moment.

    Table =
CALCULATETABLE (
    VALUES ( 'Table'[Name] ),
    FILTER ( ALL ( 'Table' ), YEAR ( 'Table'[Created_At] ) = 2021 )
)

    Thanks for your efforts & time in advance.

     

    Best regards,
    Community Support Team_ Binbin Yu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • quyenduong's avatar
      quyenduong
      Helper II
      3 years ago

      I updated the screenshot of the result I want to achieve in the main post. Thank you