Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

different words for one generic keyowrd

Hi 

 

I need some help to create a word cloud.

 

My problem is that I want to create a keyword list. The individual keywords should be a generic term for different words.

 

For example the keyword is display.

In another list I want to set the words monitor, screen, display, panel... to the keyword display. 

 

Do you have any idea how to code this.

 

Thanks

Need Help

4 Replies

  • v-juanli-msft's avatar
    v-juanli-msft
    Icon for Community Support rankCommunity Support
    7 years ago

    Hi Anonymous 

    Do you want to create a keyword list based on exsiting data?

    If so, could you show an example of the data and clear me the rule to exact the key words from it?

     

    As searched, you could follow this guide to create a word cloud in Power BI.

    https://www.youtube.com/watch?v=AblTenl9fqo

    https://www.sqlshack.com/how-to-create-a-word-cloud-generator-in-power-bi-desktop/

     

    Best Regards
    Maggie

     

    Community Support Team _ Maggie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Yes you are right! v-juanli-msft 

       

      I want to create an own list. In this list I want to have keywords and the different keywords should be a definition for some other terms.

       

      After that I want to use this keyword list to count how often it shows up in the incoming tickets...

      Normally if I search for the keyword "display" it only shows how often "display" appears in the tickets. But I want that it counts whenever the cognate term for example "monitor" or "screen" appears.

       

      I hope you understand what I need.

       

      • v-juanli-msft's avatar
        v-juanli-msft
        Icon for Community Support rankCommunity Support
        7 years ago

        Hi Anonymous 

        Do you have all words in on one column

        list
        monitor
        screen
        display
        panel
        fruit
        banana
        apple
        apple
        panel
        screen
        screen
        apple
        cloths
        t-shirt
        t-shirt
        t-shirt
        skirt
        trouser

         

        Or have data as below

        name explain
        monitor it is display
        screen a kind of display
        panel best sale display
        banana good fruit
        apple fruit you like
        apple fruit
        panel it is display
        screen a kind of display
        screen best display
        apple fruit
        t-shirt cloths
        t-shirt cloths
        t-shirt cloths
        skirt cloths
        trouser cloths

         

        Best Regards
        Maggie

         

        Community Support Team _ Maggie Li
        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.