Power BI

Understanding the different approaches to date calculations using Power BI DAX formulas is crucial for efficient dashboard development. This comprehensive guide consolidates various date calculation methods, offering clear, concise explanations and practical techniques. It is meant to help people get started with date calculations and act as a quick reference guide to build dashboards quicker …

Power BI DAX Date Formulas Explained with Examples Read More »

Text wrapping in Power BI is set at the individual visualization level. Text can be set to wrap automatically, or it can continue unwrapped at the risk of being cutoff when the incoming data changes. We’ll explain how to toggle word wrap on and off in Power BI and suggest some best practices to maintain …

How to Enable or Disable Text Wrapping in Power BI Read More »

Getting column widths exactly how you want them in Power BI Matrix and Table visuals can be more challenging than you would think. We’ll explain how to auto-fit columns, adjust the width so they’re all the same, and some helpful techniques to get the formatting just right. Unfortunately, at this time there is no direct …

How to Change and Specify Width of Columns in Power BI Read More »

Creating custom tooltips are a great way to give Power BI report viewers a way to get additional insights into a report without having to drill through to another page. Tooltips are unique in Power BI in that they allow you to show custom sets of information when someone mouses over an existing visual. Tooltips …

How to Create and Format Custom Tooltips in Power BI Read More »

Report viewers who are new to the Power BI platform are often unaware of how to drill through a report into other report tabs that provide more detail. Compounding the problem is that Microsoft did not provide a way for people to drill through a report unless they right click on a visual and select …

Setting up Left Click Drill Through in Power BI Read More »

Power BI DAX Variables are an incredibly useful tool when creating long complex formulas that help you keep track of different tables and fields being referenced throughout. They have many benefits including making formulas easier to read, more modular, and help you hedge against changes that may occur within the underlying data model. We’ll explain …

Power BI DAX Variables Explained with Examples Read More »

Power BI Quick Measures are pre-made templates for creating DAX Measures that enable Power BI developers to write complex formulas in a matter of seconds. They’re extremely easy to use, and great for both beginners new to creating DAX measures and seasoned Power BI developers looking to save some time when creating dashboards. Power BI …

Whey Everyone Should Know Power BI Quick Measures Read More »

Measures are a cornerstone of dashboard development using Power BI. We’ll explain what measures are, why they’re important and highlight some of the most important ones to be aware of to get you started. We’ll explain what measures are, their significance, how they differ from Excel formulas, and some considerations to keep in mind when …

An Introduction to Creating Measures in Power BI Read More »

Removing rows from a Power BI dataset is typically done at the data model level using Power Query. An alternative option is to apply filter criteria to a page if you want to keep the primary dataset intact and only remove rows for a specific portion of your report. We’ll explore both methods and explain …

How to Delete and Remove Rows in Power BI Read More »

Trend lines are an invaluable tool in data analysis. We’ll explain how to add them to Power BI visuals to give your report viewers a quick way to tell how things are trending. While not all chart or graph types in Power BI support trend lines there are some workarounds to re-create the look of …

How to add a Trend Line to Visuals in Power BI Read More »