How to create a quick Sales Dashboard in Power BI?

In this tutorial, let’s build an interactive, simple & elegant sales dashboard using Power BI. Use this lesson to understand the report building process and gain basics of Power BI.

This is what we are going to build:

Author: Chandoo

My name is Chandoo. I am going to make you awesome in Excel, VBA, Dashboards, Power BI & Power Pivot and answering your questions. I live in Wellington, New Zealand. It is a beautiful, small city on the southern edge of the world. I run my own Excel Consulting & Training business from here. I am married to my college sweet-heart, Jo. We have 2 kids – twins. They are 10 years old now. They are busy creating new worlds with lego bricks or playing or learning. We (Jo &I) are busy with cooking, eating, walking, talking and reading.

19 thoughts on “How to create a quick Sales Dashboard in Power BI?”

  1. Hi ,Teacher
    How to get the logo in the upper left corner and which website can download such similar logo. I can’t paste it directly into my personal folder.

    1. Qingjian.. you can create such logos using any image editing software. I normally make these in Power Point, screenshot and crop the image. Save the image file and use “Insert image” button to add them to your report pages in Power BI.

  2. Hii Chandoo..

    I am not able to upload access data to power BI. Does it require to use paid version of access to use?
    I can open the data out of power BI in free downloaded access.

    Deepa

        1. I couldn’t do this at the beginning, but now I can. I done this by going to Get Data > More > Access Database Click connect and choose file from folder.

  3. Hi,
    in about 9th minute you apply some formatting to the module.

    What if I have different modules already and I would like to change the formatting of them based on new formatting. Is it possible to copy just formatting, not the whole module? Something like Ctrl+Shift+C and Ctrl+Shift+V in powerPoint?

  4. 15:40 minute of 2nd film.
    You are talking about Symmetry Shading, but this feature doesn’t exist in current version of Power BI, was it moved somewhere else? If not, do you have any other ideas how to achieve the same?

      1. Hi Chandoo

        I have the latest version.
        But I open your file and I see that this option is there, but when I was doing everything step by step, following your instructions, it wasn’t there.

        Unfortunately I didn’t save my file, so I can’t check it now. I will make it again and then I’ll let you know how it is looks like.

  5. Hello Chandoo

    Was going through the tutorial video on creation of sales dashboard and the very first step to upload data in power BI.

    The data set is in multiple tables of Access database and how to combine and build the relationship to have 1 database for the report creation is not mentioned.
    Request if you could guide this step to complete the learning of this session
    Regards
    Atin

  6. Hi there I cannot access any power BI material. I’ve tried to email and comment before and have had no response. Id really like to do this course can someone please assist me with this?

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.