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 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 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 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. 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 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 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 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 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 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 Read more…