Tag: Dynamic Power BI Reports

Building Power BI Reports: Organizing DAX Measures & Page Development

Building Power BI Reports- Organizing DAX Measures & Page Development

In this tutorial, I’m going to show you my process in building Power BI reports and how I organize my DAX measures to help me navigate my report smoothly. I will focus mostly on how I developed the Defects and Downtime analyses on this report. I’m going to use the report I submitted as my

Continue reading

Financial Year Dynamic Filtering In Power BI Reports

Financial Year Dynamic Filtering In Power BI Reports

In this tutorial, I’ll discuss how to display information based on financial year within Power BI reports. However, this particular analysis is a bit complex. This is because it has different customers and each of them has a different financial year. You may watch the full video of this tutorial at the bottom of this

Continue reading

SELECTEDVALUE DAX – Harvesting Slicer Selection

SELECTEDVALUE-DAX-–-Harvesting-Slicer-Selection

In this tutorial, I’ll show you how to harvest or capture a value inside a measure to reuse in another measure and achieve dynamic calculations. I use a combination of measure branching technique with SELECTEDVALUE DAX function in Power BI. You may watch the full video of this tutorial at the bottom of this blog.

Continue reading

Interactive Reports In Power BI | Enterprise DNA Tutorial

Interactive-Reports-In-Power-BI-_-Enterprise-DNA-Tutorial

I’m going to showcase a few of the techniques that I’ve used to create interactive reports in Power BI utilizing interactivity buttons or bounces as I call them. You may watch the full video of this tutorial at the bottom of this blog. I’ve used these techniques in some of my recent submissions to the

Continue reading

Bookmarks In Power BI – Grouping by Report Page

Bookmarks-In-Power-BI-Grouping-by-Report-Page

I’m going to show you how I utilize bookmarks in Power BI. For example, if I have multiple bookmarks throughout the pages of my report, I’m going to demonstrate how I group and organize them in a fashion to make it easier to navigate between each one of those bookmarks. You may watch the full

Continue reading