Part II – How To “Beautify” The Heatmap Matrix Visual in Power BI In the previous tutorial (Part I) we have covered how to use the built-in matrix visual in Power BI to create a heatmap data visualization. It relies on the option to conditionally format the cell background colour Read more…
Part I – How To Create a Heatmap Data Visualisation Based On a Ticketing System If you prefer to watch a video tutorial please scroll down to the bottom of the page ⤵️ What Prompted The Idea? Well, I was walking past a Post Office when I saw the below Read more…
If you are about to start your journey with Power BI Dataflow, I suggest developing a standard calendar or date table that everyone within the organization can use. Power BI Dataflows are all about reusing clean and pre-approved data, so having a company-wide approved calendar table to use in reporting Read more…
Sometimes it is not too efficient to manually adjust the DAX code of the Field Parameters and create a column for grouping. Let’s say when you have more than 8-10 fields, you are probably better off with some dynamic grouping. One of the easiest (and probably best) ways to do Read more…
With the introduction of Field Parameters in Power BI, report creators were given a tool to provide a better User Experience in reports. But with great powers comes great responsibility… In other words, if you add lots of fields to the Parameter Table in Power BI it will be difficult Read more…
With the introduction of Field Parameters in Power BI, report creators were given a tool to provide a better User Experience in reports. But with great powers comes great responsibility… In other words, if you add lots of fields to the Parameter Table in Power BI it will be difficult Read more…
Full Calendar vs Trimmed Calendar We all know that having a Date Table in Power BI is a must to achieve reliable and good Time Intelligence functions and measures. But did you know that these measures could work with both a Full Calendar and a Trimmed Calendar? In today’s video, Read more…
What options do you have when something goes wrong with a Dataflow in Power BI? Well, there are quite a few options to use and each offers a different way of handling problems. If you want to learn more check out the below tutorial 👇👇👇 Roland 🙏Thanks for watching and Read more…
Today I would like to present two “issues” that I reckon many of you faced before. The first one is sorting month names chronologically in a custom Calendar/Date table, and the second one is sorting customers based on a custom sort order. So, you have followed a Power BI Best Practice Read more…
Today I am going to tackle a problem that doesn’t involve sales-related data. Why? Because not all Power BI reports should be about sales figures. Let’s say that I am the owner of a popular mall here in Sydney. One of the many features of a shopping centre is those Read more…