Welcome to the post about coding a transparent color in Power BI. This little trick used to be needed alllll the time, but recently Microsoft has added transparency sliders to a lot of chart elements. That doesn’t mean that we can forget about knowing how to code transparency, however, because…
How to restore the original card visual
Welcome to our quick post / video about how to get the original Power BI card visual BACK into Power BI.I posted about this quickly on LinkedIn, but thought I should also make it a post here for you, because I find the Card Visual incredibly useful, and Microsoft has…
How to figure out what a Semantic Model is.
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…