Tag: Dynamic Power BI Reports

Sort Legend Power BI Feature Tutorial And Review

As part of a mini-series that I’m doing on Power BI’s November 2021 updates, I’d like to tackle the Sort Legend Power BI feature for today’s blog. It’s a nice functionality that they’ve added to the program, so I want to show where that resides, and talk about some of the nuances of how it

Continue reading

Power BI Page Navigation Updates, Tutorial, & Review

One of the most interesting features in the November 2021 Power BI update is the new Page Navigator feature. This feature dramatically expedites the creation of Power BI page navigation buttons throughout your report. In this tutorial, I explain how to access and use this new feature. Also, I’ll go over its strengths and weaknesses.

Continue reading

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 analysis is a bit complex. This is because it has different customers and each of them has a different financial year. You can watch the full video of this tutorial at the bottom of this blog.

Continue reading

SELECTEDVALUE DAX Example- Harvesting Slicer Selection

SELECTEDVALUE-DAX-–-Harvesting-Slicer-Selection, selectedvalue dax example post image

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 techniques with SELECTEDVALUE DAX function in Power BI. You may watch the full video of this tutorial at the bottom of this blog.

Continue reading