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

Power BI

custom tooltips in power bi

Custom Tooltips in Power BI

June 2, 2022 by Philip Treacy

When you hover your mouse over an element in a visual, like a column in a clustered column chart, a tooltip like this appears. The mouse is over the first orange column so the tooltip is showing the country, year, and sale total for that column. The country could be removed as you can tell …

Read moreCustom Tooltips in Power BI
conditional formatting tables and matrices in power bi

Conditional Formatting in Power BI Tables and Matrices

May 19, 2022 by Philip Treacy

Conditional formatting in Power BI visuals allows you to draw attention to, or highlight, data in text or numeric fields using color, icons or data bars. You can also assign URL's to fields to make them clickable and load web pages. Let's look at how to apply all of these different types of conditional formatting. …

Read moreConditional Formatting in Power BI Tables and Matrices
dax editor keyboard shortcuts

DAX Editor Keyboard Shortcuts

March 17, 2022 by Philip Treacy

Writing DAX is hard enough. If there were some way to make the experience a little easier wouldn't that be great? To that end, below is a list of keyboard shortcuts you can use in the Power BI Desktop DAX Editor. Watch the Video To See What These Shortcuts Do Download DAX Editor Shortcuts PDF …

Read moreDAX Editor Keyboard Shortcuts
fixing incorrect totals in dax

Fixing Incorrect Totals in DAX

January 20, 2022 by Philip Treacy

Typically in Power BI visuals like a matrix or a table, and in pivot tables in Excel, we expect the totals to be the sums of the individual rows. This is probably because we are so used to adding up columns in Excel. In this example image (below) I've written a measure called [Target] to …

Read moreFixing Incorrect Totals in DAX
highlighting data in power bi visuals

Highlighting Data in Power BI Visuals

April 29, 2021 by Philip Treacy

In this post I'll be looking at ways to highlight or label values that may be of special interest in visuals. Perhaps you are interested in seeing the minimum and maximum values, or some data points of significance like when your business held a promotion. Or you might want to highlight points that fall within …

Read moreHighlighting Data in Power BI Visuals
Power BI Organizational Data Types

Power BI Organizational Data Types in Excel

April 21, 2021 by Mynda Treacy

Power BI Organizational Data Types in Excel allow you to store attributes about your data in a single cell. This rich data can then be referenced with the formulas we know and love. Imagine having a single cell that contains everything you need to know about a product or employee or a company, to name …

Read morePower BI Organizational Data Types in Excel
shape maps in power bi

Shape Maps in Power BI

April 15, 2021 by Philip Treacy

In this post I'm going to show you how to use Shape Maps in Power BI, which are currently a preview feature. Typically, Shape Maps are used to illustrate the variation of a variable across a geographic area like a country or state. But you can also create custom shape maps for things like buildings, …

Read moreShape Maps in Power BI
static data tables

Static Tables in Power Query, Power Pivot and Power BI

March 31, 2021 by Philip Treacy

Ordinarily when you want to create a table in Power Query, Power Pivot or PBI, you'd write a query to load it from an external source. But any time you have data that won't change (or changes rarely), you can use a static table. That is, a table that doesn't need a data source, it …

Read moreStatic Tables in Power Query, Power Pivot and Power BI

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

March 11, 2021 by Philip Treacy

When you deal with elapsed time in Power Query you can make use of the Duration data type. Howevere when you load this into the Data model in either Power Pivot or Power BI, these durations are converted to decimal values. This post looks at how to use DAX to convert these decimals into human …

Read moreConverting Decimal Time to Days, Hours, Minutes, Seconds in Power BI
Power BI Dashboards

How to Build 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 …

Read moreHow to Build Power BI Dashboards
  • 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
 
  • About My Online Training Hub
  • Contact
  • Disclosure Statement
  • Frequently Asked Questions
  • Guarantee
  • Privacy Policy
  • Terms & Conditions
  • Testimonials
  • Become an Affiliate

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.