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:

Online Classroom – Chandoo.org
Excel | Power BI | SQL | Coding | VBA and More
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:
You must be logged in to post a comment.
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.
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.
Thank you teacher, this is a good way.
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
Can you check again please? I could upload this workbook & associated data to PowerBI.com by using “Publish” button. I am using free version. Here is a link to the public version of the same dashboard.
https://app.powerbi.com/view?r=eyJrIjoiZDI1M2Y2MWUtZTZmYi00NDJmLTk0ODItMTM4ZTJlMWI4OGE5IiwidCI6IjUzNTA4ZDUyLWQxYjAtNDliMC1iNGJhLTM1MzNjMTI0OWEwMSJ9
Hi Chandoo,
I have the same problem. Power BI can not upload your acces data. Please help.
Gr,
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.
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?
You can use format painter icon on the home ribbon for this. Select the shape / visual that is already formatted, click on “Format painter” and select other visuals.
Thank you.
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?
Hi Tomasz… Symmetry shading has been around for quite sometime. It works with scatter plots. Can you please confirm which version of Power BI you are using?
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.
The problem is solved, thanks you!
Hi,
I cannot seem to download the sample data set or connect/download the PBI file? What format is the data set in?
Thanks.
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
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?
@Zoey
Please note that you have subscribed to Excel School + Power Pivot Online Course Package,
which doesn’t include Power BI classes.
Please write to purna.duggirala.va@gmail.com if you wish to add Power BI classes to your ID
Hii chandoo
I’m unable to access sample data and work book. Can you pls help me with this