ALL Blog Posts
📊 PBI Column Chart 📊 Step Your Game Up
Don't make the mistake of going with the standard settings in the Power BI Core Visuals column chart. Here's how to level up your column chart game with 3 easy steps. The standard column chart in Power BI doesn't look too amazing unless you get a bit jiggy with the settings. As you can...
KPIs & Line Charts, a Perfect Match 😍
The Power BI KPI card & line chart are the perfect combination for time series information such as sales for a given period.Let's review why these are such a good match.✅ Line chart - great for showing a monthly amount, such as sales vs last year. However when you show each sales amount by the...
PBI Line Chart – Step Your Game Up
Don't make the mistake of going with the standard settings in the Power BI core visual line chart. Here's how to level up your line chart game in 4 easy steps. 👍The standard line chart in Power BI doesn't look too great unless you get jiggy with the settings.As you can see in this example: 😡 The...
Cole Nussbaumer Knaflic’s “Storytelling with Data.”
My first ever data visualization book that I read was Cole Nussbaumer Knaflic's "Storytelling with Data."A book I highly recommend!I really enjoyed the book and after reading it I was really keen to start implementing some of the awesome visual techniques I had learned in her book.But Power BI had...
PBI Canvas Sizes, Don’t Use The Default!
One of the biggest mistakes I made in my first year of developing Power BI reports was going with the standard canvas size.I would start up a new Power BI report, put a few visualizations on the page, and then wondered why I ran out of room very, very quickly.What a lot of newbies, and maybe some...
PBI Error Bars, The Ultimate Column Chart Data Label Hack
Make Power BI Column chart Data labels great! (not again, as I don't think they were ever great 😂)Making enough room for the Y-axis on the column chart so the data labels look good is one of the things in Power BI that drives me nuts.The chart should just have enough room on the Y-axis for the...
PBI’s Little Secret, Transparent Hex Codes
Power BI has a little secret when it comes to colors and hex codes….. 🤫Do you know that you can make pretty much anything that has a conditional formatting option in Power BI visuals fully transparent?Yes, that means that you can enforce transparency on any element of visual that has the little...
Dynamic Format Strings with Power BI
There are a few different ways of formatting numbers with Power BI, but one way that is really useful is to use dynamic format strings. This is especially useful if you have numbers that cover a range (thousands, millions etc) and may also have different kinds of values, such as dollars, numbers,...
Coolors in Power BI Reports
Coolors in Power BI Reports My favourite site for getting hex codes and everything to do with colours for power bi is Coolors:https://lnkd.in/gf73Ye6MGetting colours that are right and fit for purpose is so important that if you get it wrong it can make or break your entire report!The site makes...
Showing data labels above the x axis for Power BI Line and Column Chart
Getting data labels in Power BI to look good can often be quite annoying.The labels on a chart can very often bump into one another or get in the way of reading the actual visualizations which the chart is there to show. An example of standard data labels: Note that in order to read the labels,...