• Skip to main content
  • Skip to header right navigation
  • Skip to site footer

My Online Training Hub

Learn Dashboards, Excel, Power BI, Power Query, Power Pivot

  • Courses
  • Pricing
    • Free Courses
    • Power BI Course
    • Excel Power Query Course
    • Power Pivot and DAX Course
    • Excel Dashboard Course
    • Excel PivotTable Course – Quick Start
    • Advanced Excel Formulas Course
    • Excel Expert Advanced Excel Training
    • Excel Tables Course
    • Excel, Word, Outlook
    • Financial Modelling Course
    • Excel PivotTable Course
    • Excel for Customer Service Professionals
    • Excel for Operations Management Course
    • Excel for Decision Making Under Uncertainty Course
    • Excel for Finance Course
    • Excel Analysis ToolPak Course
    • Multi-User Pricing
  • Resources
    • Free Downloads
    • Excel Functions Explained
    • Excel Formulas
    • Excel Add-ins
    • IF Function
      • Excel IF Statement Explained
      • Excel IF AND OR Functions
      • IF Formula Builder
    • Time & Dates in Excel
      • Excel Date & Time
      • Calculating Time in Excel
      • Excel Time Calculation Tricks
      • Excel Date and Time Formatting
    • Excel Keyboard Shortcuts
    • Excel Custom Number Format Guide
    • Pivot Tables Guide
    • VLOOKUP Guide
    • ALT Codes
    • Excel VBA & Macros
    • Excel User Forms
    • VBA String Functions
  • Members
    • Login
  • Blog
  • Excel Webinars
  • Excel Forum
    • Register as Forum Member

How to Build Power BI Dashboards

You are here: Home / Power BI / How to Build Power BI Dashboards
Power BI Dashboards
November 3, 2020 by Mynda Treacy

Demand for data visualisation skills is showing no signs of slowing. There are many BI tools available, and this can make knowing which one to learn overwhelming.

Global research and advisory firm, Gartner, has recognised Power BI as the Magic Quadrant Leader in analytics and business intelligence platforms for 13 consecutive years. This is just one of many reasons you should learn how to build Power BI dashboards and reports like the ones below:

Tip: click the bars/columns/lines/labels in the charts to interact with the report and trigger cross filtering and highlighting.

Mac Users: the Power BI Desktop app used to build the reports and dashboards is not available for Mac. However, you can view completed Power BI reports and dashboards using the online Power BI Service or mobile app, and depending on your dataset, in some cases you can author reports in the Power BI service.

How to Build Power BI Dashboards Video

In the video below I teach you step by step how to build the reports you see above. Starting with the process of getting data, modelling it, and then visualising it with Power BI Desktop, before publishing your reports to the Power BI service for secure sharing with your audience.

Subscribe YouTube



Trustpilot


Download the Power BI Desktop and Data Files

Enter your email address below to download the files.

By submitting your email address you agree that we can email you our Excel newsletter.
Please enter a valid email address.

Download the files and follow along. Note: This is a .zip file. You will need to unzip the files after downloading.

More Power BI Resources

Learn Power BI, Power Query and Power Pivot with Mynda. Get up to speed fast with these focussed courses that’ll have you impressing your boss and co-workers with amazing interactive Power BI reports that refresh without you lifting a finger. Get all 3 courses in a discounted bundle from the Power BI course page.

Download Power BI tools including the Desktop and Mobile apps (free)

Sign up for a Power BI Service account (requires work or school email address)

Don't have a work or school address? Use this workaround to get Power BI without a valid email address.

Power BI Dashboards

More Power BI Posts

combine files with different column names in power query

Combine Files With Different Column Names in Power Query

Learn how to load data into Power Query when the column names in your data don't match up. Sampe files to download.
try otherwise power query iferror

IFERROR in Power Query Using TRY OTHERWISE

Using TRY..OTHERWISE in Power Query Replicates Excel's IFERROR So You Can Trap and Manage Errors In Your Queries.
easily compare multiple tables in power query using list functions

Easily Compare Multiple Tables in Power Query

Compare tables or lists in Power Query using List Functions. This method is great when dealing with 3 or more tables or lists.
fuzzy matching in power query

Fuzzy Matching in Power Query

Use fuzzy matching to compare non-identical text strings and match them together based on how similar one string is to the other.
handling http errors in power query and power bi

Handling HTTP Errors in Power Query and Power BI

Clearly communicate issues with custom messages when dealing with web scraping or API server errors. Download sample Excel and Power BI files
extract characters from strings in power query using text select and text extract

Extract Letters, Numbers, Symbols from Strings in Power Query with Text.Select and Text.Remove

Learn a cool technique to extract or remove letters, numbers and special characters from strings. Sample workbook to download
highlighting data in power bi visuals

Highlighting Data in Power BI Visuals

Learn several techniques to highlight or label important data points in your Power BI visuals. Sample file and code to download.
shape maps in power bi

Shape Maps in Power BI

Shape maps in Power BI can be used to show the distribution of a variable across geographic regions. Learn a trick to plot discrete data too.

Converting Decimal Time to Days, Hours, Minutes, Seconds in Power BI

Convert times and durations from decimal numbers to easily understood formats like hh:mm:ss. Sample code and file to download.
sort by column in power bi

Sort-By Columns in Power BI

Create a Sort-By column to allow custom sort order in your Power BI Visuals. Download an example Power BI Desktop file

More Power BI Posts

custom tooltips in power bi

Custom Tooltips in Power BI

Create custom tooltips for Power BI visuals. Use charts, images, numeric or categorical data to enhance the information your visuals convey
conditional formatting tables and matrices in power bi

Conditional Formatting in Power BI Tables and Matrices

How to apply conditional formatting to tables and matrices in Power BI. Use color, icons, data bars and URL's.
dax editor keyboard shortcuts

DAX Editor Keyboard Shortcuts

Keyboard shortcuts for the DAX editor in Power BI. Learning DAX is hard enough. Make your life easier by using these keyboard shortcuts.
fixing incorrect totals in dax

Fixing Incorrect Totals in DAX

If you're getting incorrect totals in your DAX measures, this post explains how to fix them. VIDEO and Sample file to download.
highlighting data in power bi visuals

Highlighting Data in Power BI Visuals

Learn several techniques to highlight or label important data points in your Power BI visuals. Sample file and code to download.
Power BI Organizational Data Types

Power BI Organizational Data Types in Excel

Power BI Organizational Data Types in Excel revolutionize the way we store and access our data with one central location and small files.
shape maps in power bi

Shape Maps in Power BI

Shape maps in Power BI can be used to show the distribution of a variable across geographic regions. Learn a trick to plot discrete data too.
static data tables

Static Tables in Power Query, Power Pivot and Power BI

Use static tables to store data in Power Query, Power Pivot and Power BI without needing to load data from an external source

Converting Decimal Time to Days, Hours, Minutes, Seconds in Power BI

Convert times and durations from decimal numbers to easily understood formats like hh:mm:ss. Sample code and file to download.
Power BI Dashboards

How to Build Power BI Dashboards

This video tutorial takes you step by step through building Power BI dashboards and reports, including publishing and sharing.


Category: Power BITag: Power BI
Previous Post:Create a List of Matching Words When Searching Text in Power QueryCreate a List of Matching Words When Searching Text in Power Query
Next Post:Excel Dashboards vs Power BI Dashboardspower bi v excel dashboards

Reader Interactions

Comments

  1. Nkitseng

    February 14, 2023 at 3:50 pm

    Thanks for this tutorial. Mind blowing stuff. Between PBI premium and pro, which one is more ideal for organizations? I would like to share reports with executive management and they should be able to interact with the visuals.

    Reply
    • Mynda Treacy

      February 14, 2023 at 5:05 pm

      Premium is for organisations with hundreds of Power BI users, Pro is for everyone else

      Reply
  2. Tes

    January 27, 2023 at 7:11 pm

    Hello!
    Do you know any good tutorial to build databases in MS Access and use them in Power BI?

    Reply
    • Mynda Treacy

      January 28, 2023 at 7:03 am

      No, I don’t, sorry.

      Reply
  3. Bianca

    October 9, 2022 at 12:55 am

    Just want to say Thank You for the youtube video showing how to create a PBI dashboard and put it up on the web. Following through on an actual case study is far more effective than reading a book. It’s good to see how one can interact with a PBI dashboard from a blog like this one. And your example .pbix file was built in 2020, making it usable to my version of PBI Desktop which is the limit of what I could install because of Windows 7. All in all, thanks for a job well done!

    Reply
    • Mynda Treacy

      October 9, 2022 at 8:18 am

      Wonderful to hear, Bianca!

      Reply
  4. Ria

    June 23, 2022 at 8:11 pm

    hi, I am trying to get data from mpp file into Power BI to create dashboard. I dont have project web app and there is no functionality I could find in sharepoint to design one. Can you please guide what’s the way around? I tried with export of project online to excel and bring excel data into Power BI but then the data doesnt get transformed into useful dataset. Can you please guide?

    Reply
    • Mynda Treacy

      June 24, 2022 at 4:01 pm

      Hi Ria,

      You can try using the Odata feed connector as explained here.

      Mynda

      Reply
  5. Heather

    June 21, 2022 at 2:46 am

    I cannot get the line chart to work for month or year. It will only form a line if I only select “day,” because the Forecast and Budget files only contain information from January 2020.

    Reply
    • Mynda Treacy

      June 21, 2022 at 9:25 am

      Hi Heather,

      Great to see you’re having a go at building the dashboard. Please read the file called ‘READ_ME_FIRST.txt’ as this explains the issue you’re having and how to fix it so you’re not just seeing January data.

      Mynda

      Reply
  6. Madhabi

    February 15, 2022 at 3:56 am

    Madhavi says
    Here I have a question..
    In power bi of financial report there some problem occurs me. That is in the report of header part the visualization part has been occupied by format text box and subtitles are same only the heading name changed.How can i replace it?

    Reply
    • Mynda Treacy

      February 15, 2022 at 10:18 am

      Hi Madhabi,

      I’m not sure what you mean. Please post your question and sample file or screenshots on our Dashboards forum where we can help you further: https://www.myonlinetraininghub.com/excel-forum

      Mynda

      Reply
  7. Ayobami Oni

    February 2, 2022 at 9:25 pm

    please, i would like to download the dataset used in the tutorial video. Thank you

    Reply
    • Mynda Treacy

      February 3, 2022 at 9:32 am

      The link is above, under the video.

      Reply
      • Sanket

        February 23, 2022 at 4:38 pm

        The link for download the files are not working, please let us know is there any other option to download the data.

        Thanks in advance.

        Reply
        • Philip Treacy

          February 23, 2022 at 4:41 pm

          Hi Sanket,

          The file download link works fine for me. What exactly is the issue/error message you are getting?

          Regards

          Phil

          Reply
  8. Henri Dormoy

    May 2, 2021 at 1:00 pm

    The data Provided has “dd/mm/yyyy” format which was giving me errors throught the excercise. I had to reformat so it coincides with the format in my PC… You might want to mention this

    Reply
    • Mynda Treacy

      May 2, 2021 at 8:57 pm

      Hi Henri, you can just use Change Type Using Locale to convert the dates to your format. I’ve put a note in the zip file for future. Mynda

      Reply
  9. Patrick Pierre

    January 24, 2021 at 12:41 pm

    Hi, Simply amazing content! I’m new to Power Bi is there a way to make Power Bi look and feel like a website. I want to provide the end user something there already familiar with. Thanks for your help.

    Pat

    Reply
    • Mynda Treacy

      January 24, 2021 at 3:43 pm

      Glad it was helpful, Patrick! You can embed your Power BI reports in web pages so they are seamless. See the example on my Power BI course sign up page.

      Reply
  10. Faramarz Hozouri

    December 27, 2020 at 12:49 am

    Hello
    Most of my zip files open, except BI desk top and data files. zip.

    Reply
    • Mynda Treacy

      December 27, 2020 at 12:53 pm

      Not sure why that would be, Faramarz. I assume you have downloaded and installed the Power BI desktop app?a

      Reply
  11. Ved parkash aseri

    November 16, 2020 at 5:39 pm

    Mem thanks

    Reply

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Current ye@r *

Leave this field empty

Sidebar

More results...

Featured Content

  • 10 Common Excel Mistakes to Avoid
  • Top Excel Functions for Data Analysts
  • Secrets to Building Excel Dashboards in Less Than 15 Minutes
  • Pro Excel Formula Writing Tips
  • Hidden Excel Double-Click Shortcuts
  • Top 10 Intermediate Excel Functions
  • 5 Pro Excel Dashboard Design Tips
  • 5 Excel SUM Function Tricks
  • 239 Excel Keyboard Shortcuts

100 Excel Tips and Tricks eBook

Download Free Tips & Tricks

Subscribe to Our Newsletter

Receive weekly tutorials on Excel, Power Query, Power Pivot, Power BI and More.

We respect your email privacy

239 Excel Keyboard Shortcuts

Download Free PDF

mynda treacy microsoft mvpHi, I'm Mynda Treacy and I run MOTH with my husband, Phil. Through our blog, webinars, YouTube channel and courses we hope we can help you learn Excel, Power Pivot and DAX, Power Query, Power BI, and Excel Dashboards.

Blog Categories

  • Excel
  • Excel Charts
  • Excel Dashboard
  • Excel Formulas
  • Excel PivotTables
  • Excel Shortcuts
  • Excel VBA
  • General Tips
  • Online Training
  • Outlook
  • Power Apps
  • Power Automate
  • Power BI
  • Power Pivot
  • Power Query
microsoft mvp logo
trustpilot excellent rating
Secured by Sucuri Badge
MyOnlineTrainingHub on YouTube Mynda Treacy on Linked In Mynda Treacy on Instagram Mynda Treacy on Twitter Mynda Treacy on Pinterest MyOnlineTrainingHub on Facebook
 

Company

  • About My Online Training Hub
  • Disclosure Statement
  • Frequently Asked Questions
  • Guarantee
  • Privacy Policy
  • Terms & Conditions
  • Testimonials
  • Become an Affiliate

Support

  • Contact
  • Forum
  • Helpdesk – For Technical Issues

Copyright © 2023 · My Online Training Hub · All Rights Reserved. Microsoft and the Microsoft Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries. Product names, logos, brands, and other trademarks featured or referred to within this website are the property of their respective trademark holders.