How to Build Dynamic Daily, Weekly, Monthly Views in Power BI (Using Field Parameters) If you’ve ever built a Power BI report and found yourself duplicating charts for daily, weekly, monthly, or yearly views — you’re not alone. It’s one of the most common (and frustrating) dashboard challenges: “Can we see this by day? Actually,
Power BI Field parameters for dynamic views Read More »
If you work with data, you probably spend a lot of your time chasing down numbers, cleaning up spreadsheets, or explaining dashboards to people who swear they sent you the right file (they didn’t). Enter Microsoft Copilot—a generative AI assistant built into Microsoft 365 apps like Excel, Word, PowerPoint, Teams, and even Power BI. It’s
Microsoft Copilot for Data Pros Read More »
Learn more about Power BI DAX functions If you’ve dipped your toes into Power BI, chances are you’ve come across DAX and thought, “Wait, what now?” You’re not alone. DAX (short for Data Analysis Expressions) is the formula language that makes Power BI so powerful—but it can be a bit intimidating when you’re just starting
Top 5 DAX Functions Every Power BI Analyst Should Know Read More »
How to use SQL Server Stored procedures in Microsoft Power BI? The aim of this blog is to take you through one example of executing SQL stored procedures in Power BI. Similar to SQL Server Reporting Services (SSRS) we can create parameters that will be used to return a result set based on the
SQL Stored Procedures in Power BI Read More »
Connecting Power BI and Google Sheets and Why It Matters In the world of data analytics and visualization, Power BI has become a go-to tool for creating insightful reports and dashboards. However, what if your data resides in Google Sheets? Fear not! In this blog post, we’ll explore how to seamlessly connect your Power
Integrating Power BI and Google Sheets Read More »
Let’s dive into the world of conditional formatting in Power BI. Whether you’re a seasoned Power BI user or just getting started, understanding how to apply conditional formatting can significantly enhance your visualizations. In this blog post, I’ll cover the basics and provide practical examples. Conditional formatting allows you to dynamically change the appearance
Conditional Formatting in Power BI Read More »
Power BI and Business Central Does your company use Business Central. Today I’ll be showing you how to connect Power BI and Business Central using the Odata connector. Microsoft Business Central is an all-in-one business management solution that helps organizations streamline their processes, improve visibility, and drive growth. It offers comprehensive functionalities for finance,
Power BI and Business Central Read More »
Dynamic Format Strings in Power BI In this post, I’m going to show you how to use dynamic format strings in Power BI to make your measures look awesome. Dynamic format lets you change the way your measures appear in visuals based on conditions or context. For example, you can add currency symbols, abbreviate
Dynamic Format Strings in Power BI Read More »
The New Card Visual in Power BI: A Game Changer for Dashboard Design Hold onto your data hats, folks, because the Power BI revolution just took a big step forward with the New Card Visual! If you’re tired of the limitations of the legacy card visuals and yearning for more flexibility and finesse, then rejoice!
The New Card Visual in Power BI Read More »
Hey all. If you’re like me, you love using Power BI to create awesome data visualizations and reports. But sometimes, you might feel like it takes too long to do certain tasks or navigate the interface. That’s why I’m here to share with you some of my favourite shortcuts in Power BI that will
Best Power BI Shortcuts for Efficiency Read More »
