Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Reading Text into Power BI

Hello!

 

I have been asked to create what is essentially an interactive PowerPoint presentation in Power BI. For this I must be able to read text into Power BI and have them presented in a bullet point format. (The bullet point can be done in excel, I just need a method to create a list of "text" values).

 

The best I have done so far is read in only one bullet point into a  card. I am not very experienced with DAX, so I am not certain this is possible. Any suggesteions are appreciated!

 

Thank you!

Need Help

3 Replies

  • Tahreem24's avatar
    Tahreem24
    Super User
    6 years ago
    Can you illustrate some sample or example for better understanding?
    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      v-frfei-msft , Tahreem24 , Thank you very much for the replies.

       

      I'm sorry I did not ellaborate very well. I will provide some images here to clarify.

       

      I have various Power BI tabs that all require a different set of bullet points. (In this example, these are denoted by different "Subjects").

       

       

      This is the final result I am hoping to attain, In this picture I have simply typed the text into a text box. The idea would be to have a seperate excel spread sheet in which these commens will be typed, and then read into this tab of Power BI.

       

       

       

       

       

       

       

       

      This is what I am working with.

       

      Please keep in mind the format of the excel spread sheet (everything excep the "text") is up to me. I can modify anything. I just figured this might be one way of filtering on the bullet points that I want read into the card.

       

       

       

       

      I am little sceptical about whether this format (of the butllet points) can be achieved through an automated process. But would really appreciate any advice, even if the result is only close to what I have posted!

       

      Thanks again.

  • v-frfei-msft's avatar
    v-frfei-msft
    Community Support
    6 years ago

    Hi Anonymous ,

     

    We can create a measure using CONCATENATEX function in your scenario.

    Measure = CONCATENATEX('Table','Table'[cate])

     

     

    For more details, please check the pbix as attached.

    If it doesn't meet your requirement, kindly share your sample data and excepted result to me if you don't have any Confidential Information. Please upload your files to One Drive and share the link here.