Welcome to the post about figuring out what a “Semantic Model” is. For the past few years, Microsoft has been referring to the data you use in a Power BI report as a “Semantic Model”… so what exactly is it and does using a Semantic model affect what we do…
How to format a Table Visual
Welcome to the post about how to FORMAT a table visual in Power BI. This post will go over some basic table visual design principles to make your table visuals easier on your audience, because tables show a LOT of data at once. If you want to use the same…
How to make a Table Visual
Welcome to the post about how to make a table visual in Power BI. This is pretty easy on the surface, but tables have their own little quirks and idiosyncracies, so we’ll explore them a bit with this post. If you want to use the same Power BI file I…
How to know when to make a new column or measure in Power BI
Welcome to our post all about how to know when you should make a new column OR a new measure using DAX in Power BI, because sometimes it can be confusing about what is better. The answer, like most things, is “it depends”. If you want to use the…
DAX: DISTINCT COUNT
Welcome to our post all about the DISTINCTCOUNT function in DAX, because sometimes a COUNT isn’t good enough because it counts duplicates. If you want to use the same Power BI file I use in the below video and written notes to try out DISTINCTCOUNT, here’s the pbix file…
How to safely publish Power BI to the web
Sometimes, you really really want to publish your Power BI report to the web so that everyone can see it (without needing a Power BI license – more on that here), and this post is about why you want to think twice (or thrice, or four-ice??) about doing this.
How to build a ring donut chart
This How To Use Power BI post is all about how to make an impressive looking “Ring Donut” chart with Power BI, specifically using new border options Microsoft has added to Donut and Pie charts. The new border options are NOT super useful in terms of making charts better and…
How to (not) use new transparency and border options in Pie & Donut charts
Hey everyone! Welcome to this How To Use Power BI post, which is actually a How to NOT Use Power BI post. Freaky, right? This post isn’t a technical one that will show you what to click to get something done in Power BI, but more of a chart design…
How to search formatting options in Power BI
Welcome to the searching formatting options post on How To Use Power BI. We’re going to look at a really simple and useful formatting feature that even I forget about, even though I’ve used Power BI almost every day for years and years and years. Maybe *I* am the only…
Post Series: Pie Charts
Everything you need to know about Pie Charts! Once you’ve connected to some data, you may want to build a Pie Chart. Pie Charts are easy to build and are so easy to build (in Power BI as well as other programs) that they are frequently used.Pie charts are excellent…