Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi
I am a new user of Power BI. I have a very simple table tracking x number of devices, that have been upgraded (status = complete/scheduled), on a particular date and in a particular country.
I would like to use Power BI to improve my statis excel charts.
I would like to create a couple of charts:
1. the number of devices completed vs scheduled - bar chart.
2. the number of devices completed and scheduled per a particular week, potentially with a trend line
3. a treemap of the number of devices per a country (complete + scheduled
I would very much appreciate some assistance, without the need to code the solution.
Thank you
Chris
Solved! Go to Solution.
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. Hope you can have fun with Power BI.
Best Regards,
Qiuyun Yu
i suggest going through the guided learning videos on the power Bi site, thats the best way to learn
https://powerbi.microsoft.com/en-us/guided-learning/
Proud to be a Super User!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |