Bayes theorem in Power BI

I’ve been following Veritasium on Youtube for some time. It’s made by Derek Muller who is really awesome att explaining science! Back in 2017 he made this video on Bayes Theorem and while looking through his older videos I stumbled upon it. It’s only 10 minutes long so you...

Scheduled refreshes from files

From time to time you might want to use an Excel or CSV file as the source for your Power BI reporting. The downside of doing so is that if you specify a local file as a source, the Power BI Service wont know how to access it after...

Emails to Team chats | Give away

Want to skip right to getting your hands on a Power BI Report and play? Click here to download the Power BI template from GitHub and get started right away. Backstory “This meeting could have been an email” This is what I used to say at least. These days...

Diving data in Power BI

My sister in law has the same kind of passion for the ocean as I do for Power BI. She loves it it so many ways! She loves looking at it, swimming in it, diving in it, preaching about the dangers we pose to ourselves as a species by...

Service desk improvements in Power BI

Some time ago I was presented with Service desk data and I was recently asked to make a part 2 with more insights that could be drawn from this type of data. I though about another solution for a price development tool where I used What-if parameters of dates...

How to combine a clustered and stacked chart in Power BI

Let’s say you have a total budget, you want to compare it to your 3 income streams and you want to merge the diagrams below into one. Clearly it’s possible (I haven’t made the final diagram in paint you know) and here’s how it’s done! The issue In Power...

Dynamic segments

If you’re reading this blog post despite what is possibly the most boring title in the history of blogging, I salut you! Thanks for giving it a try and I’ll do my best to provide something for you that you will have good use for. OK so this idea...

DAX Tables – Calendar and Time

As time travelling is yet to be invented, the dimension of time tends to be rather crucial in most reporting scenarios. I can only imagine the implications time travels will have on the BI business!“As you can see the trend is going upwards! This is great!”“Yesterday I showed you...

Using Power BI for your Spotify data

I like to consider myself a good listener. To music, that is. Spotify is almost always on regardless if I’m working, driving, cooking or working out. I recently figured there must be a ton of data that Spotify has collected for me! I mean, they do come up with...

Using Power BI for business cases of Servicedesk data

From personal experience, I’d say that the Servicedesk is most likely the most data driven group in IT. Everything is measured, especially the ticket system. How many cases do we have, how many requests versus incidents, who have completed the most tickets last week, last month, this year… The...