cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
New Member

Very Simple Question

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

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support
Community Support

Hi @critchie,

 

Based on your description, I create some sample data to plot chats:

 

q1.PNG

 

1.  You can create a bar chart like below:

q2.PNG

 

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.

 

q3.PNG

 

 

 

3. Create a treemap like below. See: Treemaps in Power BI (Tutorial).

q4.PNG

 

For detail steps, you can download attached .pbix file to have a look.

 

Best Regards,
Qiuyun Yu

 

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

4 REPLIES 4
Super User I
Super User I

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/





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Community Support
Community Support

Hi @critchie,

 

Based on your description, I create some sample data to plot chats:

 

q1.PNG

 

1.  You can create a bar chart like below:

q2.PNG

 

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.

 

q3.PNG

 

 

 

3. Create a treemap like below. See: Treemaps in Power BI (Tutorial).

q4.PNG

 

For detail steps, you can download attached .pbix file to have a look.

 

Best Regards,
Qiuyun Yu

 

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

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. Smiley Very Happy Hope you can have fun with Power BI.

 

Best Regards,
Qiuyun Yu

 

 

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
November Update

Check it Out!

Click here to read more about the November 2020 Updates!

Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

secondImage

Power Platform October Community Highlights

Check out the top community contributors across all of the communities

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors