Forum Discussion
Chart for Calendar Weeks Data same like in Excel
Hi Anonymous ,
After you update the Excel file, you can either manually refresh the table from Power BI side or set up a Data Gateway. After each data refresh, the unpivoting and other operations will happen automatically. You can read more about data refresh here (https://www.c-sharpcorner.com/article/what-is-data-refresh-in-power-bi-and-how-to-set-up-schedule-refresh-in-power-bi/)
Regards,
Aditya
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
Hello,
Thanks for sharing and replying 🙂 It is looking how i imagined it. But i have one more question. Will unpivoting and converting happen automaticly each time i will update the Excel file? This is important to me as well.
BR
Wojciech
Hi Anonymous ,
After you update the Excel file, you can either manually refresh the table from Power BI side or set up a Data Gateway. After each data refresh, the unpivoting and other operations will happen automatically. You can read more about data refresh here (https://www.c-sharpcorner.com/article/what-is-data-refresh-in-power-bi-and-how-to-set-up-schedule-refresh-in-power-bi/)
Regards,
Aditya