How to Optimize Performance in Power BI
Introduction We all tend to avoid accessing super slow websites and apps. Back to the old days of the internet, somewhere in the mid 2000’s, websites that took too long…
JOAO MARTINS
How to Automatically Select Measures Based on User Login
Introduction A few months ago, an excellent youtuber name Bas Dohmen – founder of datatraining.io published an excellent video on youtube demonstrating a technique which can automatically select measures based on the user who…
How to Apply Security in Power BI
Introduction In the current Data World, security is a hot trending topic in whenever place you go, in whichever event you attend and in every company working to leverage data…
How to create a Lollipop Chart in Power BI
Introduction Storytelling with Data is one of the greatest books for everyone who is working in the Data and Analytics field. Doesn’t matter if your job is more related to…
How to Dynamically Change a Tooltip Dimension
Introduction Tooltips are a very useful feature in Power BI to extend the insights generated by a visual in a report. However, in the same way they can increase user’s…
How to build a Control Chart in Power BI (and apply them to any measure in your report)
What is a Control Chart? A Control Chart is a statistical tool used in the field of process improvement, specifically in Lean Six Sigma methodology. It is used to monitor…
How to Replicate a DAX Measure Pattern – What are & How to Use Calculation Groups
Introduction Why we would like to create Calculation Groups within our Data Model? Let’s just imagine that we’ve got a model containing several different Fact Tables that are doing a…
The Date Table
The Date Table is one of the most important tables in a Power BI model. Yet being a simple table, not using it can cause some hidden issues. Once the…
Power BI Data Modelling Best Practices
What is Data Modelling? When working with Analytical tools, we need to import data, usually in the format of tables, into the tool in order to start performing calculations and…
