Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Visualisation of data from Excel

Hi, I've downloaded basic data from my excel spreadsheet but can't visualise my data in the form of bars, pies, etc. Tried Powerbi user guide but can't proceed.

3 Replies

  • KBO's avatar
    KBO
    Memorable Member

    Hi Anonymous ,

     

    1) Go to "´Get Data" in the Power BI Desktop Client

    2) Choose Excel

    3)Choose the Table/ Sheet

    4) Load

    5) Click on a Visual under Visualization

    6) Grap the Value you like to visualize and drop this in the viusal-frame 

     

    Best,

    Kathrin

     

     

     

     

    If this post has helped you, please give it a thumbs up!
    Did I answer your question? Mark my post as a solution!

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi Anonymous ,

    Can you explain how you connect your excel data to Power BI ? You mentioned that you cannot visualize this data onto the form of bars , pies etc , could you please provide me the relevant error message or screenshot?

    In additional, hope the following documentations can help you.

    https://docs.microsoft.com/en-us/power-bi/service-excel-workbook-files#prepare-your-workbook-for-power-bi

    https://docs.microsoft.com/en-us/power-bi/service-admin-troubleshoot-excel-workbook-data

     

    Best Regards

    Rena

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi Anonymous ,

    Whether your problem has been resolved? If no, could you please provide the required info in my previous post then I can help you resolve it? Otherwise, could you please mark it as Answered since it was resolved? Thank you.

     

    Best Regards

    Rena