Forum Discussion

critchie's avatar
critchie
New Member
9 years ago
Solved

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

 

 

  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    9 years ago

    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

     

4 Replies

  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    Community Support
    9 years ago

    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

     

    • critchie's avatar
      critchie
      New Member
      9 years ago

      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

      • v-qiuyu-msft's avatar
        v-qiuyu-msft
        Community Support
        9 years ago

        Hi critchie,

         

        You're welcome. :smileyvery-happy: Hope you can have fun with Power BI.

         

        Best Regards,
        Qiuyun Yu