Category: Data Modeling

Power BI Dashboard Design – An Impressive Page Turning Visualization Idea

Power-BI-Dashboard-Design---An-Impressive-Page-Turning-Visualization-Idea

In this tutorial, I want to highlight one of the most innovative page-turning visualization ideas that I’ve seen in a Power BI dashboard design.  Many of you may know that we are running Power BI challenges on our Enterprise DNA forum. You can participate if you have access to our platform or you can check

Continue reading

Showcasing Multiple Selections In A Power BI Slicer

Showcasing-Multiple-Selections-In-A-Power-BI-Slicer

Many of you may know that we regularly conduct Power BI Challenges. There are lots of techniques that I want to highlight within these reports that are being submitted to the challenge. But in this tutorial, I’ll focus on a specific technique regarding Power BI slicer. This technique was used by Greg, who is one

Continue reading

Using Calculate Function Inside Power BI

Using Calculate Function Inside Power BI

For this tutorial, I’ll cover how the CALCULATE function works and why it’s so crucial in Power BI. I’ll also show you some examples of its application. You can easily branch out to time intelligence calculations by using the CALCULATE function. Once you apply this technique, you’ll be able to produce high quality insights inside

Continue reading

DAX Table Functions In Power BI

In this blog post, I’ll introduce you to DAX table functions. Table functions are simply DAX functions that return a table. Some of the most common table functions that you can encounter in Power BI are the FILTER, VALUES, and ALL functions. Using these table functions, you can create virtual tables inside Power BI. Physical

Continue reading

How To Use An Iterating Function In Power BI

This tutorial will teach you about different iterating functions and how to efficiently use them in your calculations. I often discuss how calculated columns are not required when making some calculations. This is because of iterators. Iterators or iterating functions can help you do a calculation without physically putting the results in the table. This

Continue reading