Have you ever built a stunning Power BI report, only to have your perfect visuals ruined by an ugly date slider? It’s a frustrating problem that can mess with the flow of your report and diminish its usability. But don’t worry—there’s a quick hack to get rid of that slider and make your charts cleaner … Continue reading How to Hack Your Date Dimension in Power BI
Category: Storytelling
How to create a stacked chart with Better or Worse indicators
Every inch of your dashboard real estate is precious. That’s why it has to be packed with as much insight as possible. I almost never use stacked charts because they don't make it easy to add useful context for each data point. Well, until now! In this video, I talk about how you can add a Better/Worse indicator to turn your stacked charts into an insight superpower!
Tutorial: DAX to remove pesky blanks from Parent Child hierarchy in charts and tables.
Should core PowerBI visuals natively support Parent Child hierarchies? Yes... do they? No... We have to deal with blanks and repeats and all kinds of things to make our charts and tables look nice. Well, in this video I offer you my approach to clean up your visualizations so they look exactly the way you want them to look.
Streak Analysis – From DAX to Reporting
If you are trying to manage customer or employee engagement, but have no quantitative understanding of impressions, engagements, and conversions, then you have zero grasp of your reach. If basics are covered, you should focus on the quality of the engagement. Streak Analysis could be very useful to understand patterns of engagement. Learn how to create the DAX calculations and use them in a report in this video.
Elevate Your Dashboard Credibility with Expert Storytelling Tips
I've just dropped a new video that dives deep into the art of crafting highly credible and compelling dashboards. https://youtu.be/RpQyKz43BnE In this video, I'm peeling back the layers on what it truly takes to enhance your dashboard's credibility. You'll learn the dual pillars of establishing trust: showcasing your competence and demonstrating honesty to your audience. … Continue reading Elevate Your Dashboard Credibility with Expert Storytelling Tips
How To Use Animated GIFs in Power BI
Never thought I would have to tackle this ever in my life, but never say never… today I actually had to figure out how to use an animated GIF as a part of my Power BI report. You might assume that this should be very simple, all you have to do is place this image … Continue reading How To Use Animated GIFs in Power BI
Forecasting Measure in Power BI
In this lab we will be implementing a forecasting measure using DAX. We will not be generating a forecast data set, rather, we will create a measure that will look at the actuals from the past to forecast what will happen in the future. We will be using a CDC data set of US Deaths. … Continue reading Forecasting Measure in Power BI
Price Volume Mix (PVM) Calculation in Power BI with New and Discontinued Products (Power BI Dax Tutorial)
Price Volume Mix (PVM) calculation is one of the most popular topics on my blog and YouTube channel. Although, I have covered the DAX for the perfect PVM before, I have gotten a lot of requests to extend the PVM logic to include a separate bucket for discontinued products as well as new products. You … Continue reading Price Volume Mix (PVM) Calculation in Power BI with New and Discontinued Products (Power BI Dax Tutorial)
Decision Tree for Data Visualizations?
Here is an interesting idea, can you have a prescriptive approach in selecting a right chart for your storytelling? In this article https://www.kdnuggets.com/2021/02/telling-great-data-story-visualization-decision-tree.html the author suggests that a simple decision tree can help you in guiding your choices. https://youtu.be/LW-50zDTteQ I found the approach to be very interesting, albeit not all branches of the decision tree … Continue reading Decision Tree for Data Visualizations?
Market Basket Analysis (Power BI DAX Tutorial)
I have decided to spend some more time on Market Basket Analysis, but before I get into the storytelling part of it, I had to clean up and fix a few things in the model file for the Market Basket Analysis that I created a few years ago. https://youtu.be/3OlZuXH9Y_g Market Basket Analysis is very important … Continue reading Market Basket Analysis (Power BI DAX Tutorial)
business intelligist 