Forum Discussion
Very Simple Question
Hi critchie,
Based on your description, I create some sample data to plot chats:
1. You can create a bar chart like below:
2. Create a calendar table, add a calculated column to return week values. Create a relationship between the calendar table and fact table. Add a trend line in a line chart. See: Analytics pane in Power BI Desktop.
3. Create a treemap like below. See: Treemaps in Power BI (Tutorial).
For detail steps, you can download attached .pbix file to have a look.
Best Regards,
Qiuyun Yu
Hi critchie,
Based on your description, I create some sample data to plot chats:
1. You can create a bar chart like below:
2. Create a calendar table, add a calculated column to return week values. Create a relationship between the calendar table and fact table. Add a trend line in a line chart. See: Analytics pane in Power BI Desktop.
3. Create a treemap like below. See: Treemaps in Power BI (Tutorial).
For detail steps, you can download attached .pbix file to have a look.
Best Regards,
Qiuyun Yu
Hello Qiuyun (you have a very interesting name ;-) )
Thank you for your assistance!
This has massively helped me to improve my dashboard. Especially the calendar week table.
Kind regards
Chris
Hi critchie,
You're welcome. :smileyvery-happy: Hope you can have fun with Power BI.
Best Regards,
Qiuyun Yu