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....
  • 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