Power BI & DAX: How to Use Breadcrumbs to Fix the Fatal Flaw of the Filter Pane

in this video I talk about the fatal flaw of the Power BI's Filter pane and how we can fix it with breadcrumbs. What fatal flaw am I talking about? What the heck is a breadcrumb? Well, watch the video and you will find out. https://youtu.be/6HHbPzqhcn8 These are the measures that I have created to … Continue reading Power BI & DAX: How to Use Breadcrumbs to Fix the Fatal Flaw of the Filter Pane

Power BI & DAX: How to Implement Dynamic Page and Chart Titles

We often need to have a dynamic title (page or chart level) that changes based on what the user has selected from the different slicers/filters on the page. In this video, I go over several strategies for accomplishing this task. I start with a very simple one, that requires no knowledge of DAX and then … Continue reading Power BI & DAX: How to Implement Dynamic Page and Chart Titles

Price Volume Mix (PVM) for Revenue Variance Analysis

EDIT 2021-01-12: the latest post and a video on how to calculate a perfect PVM is available here: DAX for the Perfect Price Volume Mix (PVM) Calculation (Power BI Tutorial) EDIT: the most recent post about this topic (and a video) can be found here: https://businessintelligist.com/2020/11/20/the-definitive-guide-to-price-volume-mix-calculation-pvm-in-power-bi-theory/ The first time I covered PVM for Revenue analysis, … Continue reading Price Volume Mix (PVM) for Revenue Variance Analysis