Unfortunately, it does happen… You have just added a new calculation group/calculation item to your model and all of the sudden, some of the visuals on your report stop working. Usually, the main reason behind is some sort of invalid DAX in your calculation group. However, sometimes this might happen even if on a surface … Continue reading What to Do When Calculation Groups Break Your Measures (PowerBI Tutorial)
Tag: PowerBI
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
business intelligist 