Forum Discussion

chad_oge's avatar
chad_oge
Frequent Visitor
6 years ago

Word Cloud - Distinct counts

Is it possible to use the Word Cloud visual to count words by distinct groups?  In the example below, I would expect these settings to count 'word' 3 times instead of 6:

 

Am I missing something here?

 

Thanks,

 

Chad

6 Replies

  • Hey,

     

    unfortunately, this is not possible, or phrasing it a little different: this is not the intention of the word cloud visual.

    Maybe you have to consider to extract the words of interest, you can use keyphrase extraction, that is described in this article: https://docs.microsoft.com/en-us/azure/cognitive-services/text-analytics/tutorials/tutorial-power-bi-key-phrases

     

    If you now the words of interest and they are few, you can also consider creating DAX measures using SEARCH or FIND

     

    Then you can build a table that has two columns the document id and the word of interest.

    Some time ago, I created a little sample analyzing emails: https://github.com/tomatminceddata/PowerBIemail

    Maybe you find this useful.

    This article provides a great introduction to the world of text analysis/text mining.

     

    Hopefully, this provides some new ideas on how to tackle your challenge.

     

    Regards,

    Tom

    • chad_oge's avatar
      chad_oge
      Frequent Visitor

      Thank you for the response and additional info.

      • Tahreem24's avatar
        Tahreem24
        Super User

        Could you please try "word-break" property in general option and then try that count.

         

         

  • az38's avatar
    az38
    Community Champion

    chad_oge 

    there is no such option in the box

    as it is a third-party solution you should send your idea to authors