Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Chart for Calendar Weeks Data same like in Excel

Dear All,

 

I am trying to make similar Stacked Chart like i did in excel, but in powerbi:

 

This is my data and chart in excel:

 

Is it possible to create the same chart in power Bi using this data, my team is storing FTE data for each Project for Certain Calendar Week. I can't make similar Chart in Power Bi. Can you advise how to do it? Is it possible to do it with this table or it should me changed? 

 

Thanks in advance for support! 

Wojciech 🙂

Need Help

8 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi Aditya,

     

    Thanks for responding, but my problem is i can put right values in chart due to this fields: 

     

    Should it be changed ?

     

    BR

    Wojciech

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Idk how to extract the Values from this kind of table:

    BR

    Wojciech

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    You can unpivot the columns in Power Query Editor. Can you please give some sample data after removing confidential data in form of excel file, so that I can try it myself?

    Regards

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        Thanks for the excel file. Here is your required solution.

        First I Unpivoted all your weeks columns and converted them to 2 columns containing attribute and value. In this way I converted the columns into rows. Then used these 2 columns for making the stacked bar chart. 

        Attaching the .pbix file
        Wojciech.pbix

        Regards,
        Aditya