My Online Training Hub
Learn Dashboards, Excel, Power BI, Power Query, Power Pivot
Are you ready to elevate your Power BI reports from standard to standout? Power BI's extensive array of settings can be overwhelming, but don't panic! In this guide, we'll show you four easy Power BI design tricks to transform your reports into visually engaging narratives that grab attention and clearly deliver your message. …
Ever felt overwhelmed by the complexity of DAX formulas in Power BI? Whether you're just getting started or have been working with Power BI for a while, mastering DAX can seem like a monumental task. But what if I told you there's an easier way to handle those calculations? Enter the brand-new Power BI Visual …
Ever felt like you're wrestling with spreadsheets, trying to make sense of overwhelming data, only to end up with static charts that barely scratch the surface of what's truly happening? You're not alone. In this Power BI tutorial for Excel users we'll turn that frustration into empowerment. Power BI's visualization capabilities are not only more …
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 …
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. …
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 …
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 …
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 …
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 …
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, …
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 …
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 …
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 …
