Category: Power BI

Forecasting in Power BI: Compare Performance vs Forecasts Cumulatively w/DAX

Compare Performance vs Forecasts Cumulatively with DAX

Showcasing results cumulatively is, in my opinion, the best way to showcase trends in your data. When comparing data versus budget or forecasts, showing the trends or divergence in trend is essential. You may watch the full video of this tutorial at the bottom of this blog. You want to make sure you can identify

Continue reading

Compare Actual Results to Budgets Using Power BI Forecasting

Budgeting-Examples-in-Power-BI-and-DAX

Budgeting in Power BI is just not that easy to implement. I wish it was as easy as bringing in your actuals and budgets and then like magic you would be able to see the insights you need visualized in a compelling way simply by using Power BI forecasting. You may watch the full video

Continue reading

Power BI Trend Analysis: Are Margins Expanding Or Contracting?

In this blog post, I will be diving into a relatively specific insight by conducting a Power BI trend analysis. By walking through exactly how I got there, you will learn so much about what you can do with Power BI and DAX. I really dive into this concept of measure branching, which I love

Continue reading

How To Do Trend Analysis In Power BI Using DAX

Power BI Tracking and Visualizing Trends

Showing trends and how they change over time can add a lot of value to your consumers and decision makers. In this post, I will show how to use conditional formatting inside Power BI tables to showcase this insight really well. Obviously to show a trend analysis in Power BI, we actually need to calculate

Continue reading

Data Visualization in Power BI: Showcasing Sales Performance Effectively

I want to show you some data visualization techniques in Power BI to create a compelling dashboard. You may watch the full video of this tutorial at the bottom of this blog. If you’re a business that sells something, you definitely want to showcase your sales performance really effectively. In this tutorial, I work through

Continue reading