Plenty to read!
All tagged DAX
In this article, we look at a 5-step process to replace fields in a report when you’ve re-named, moved, or deleted them in the model. You can also use this method to “hot swap” different fields in and out of a visual without losing formatting. This isn’t officially supported, but it’s easy and it’s a huge time-saver.
In this short article, we look at the consequences of having a case-specific collation in your Power BI semantic model. This is particularly important as Direct Lake models created in the Fabric user experience have a case-sensitive collation applied, automatically.
This ‘article’ is a short quiz you can use to practice DAX in your browser on the website dax.do.
In this article, we tackle the growing issue of ‘report-specific objects’, dataset measures and tables created to fill specific report visual requirements, why they negatively impact self-service users, and best practices to mitigate this impact.
In this article, we look at the difference between best practices and optimizations. We also define a four-step method to tackle complex issues with dataset/report performance and design.
In this article, we compare different methods to let users to dynamically select measures in reports & pivot tables.
In this post, we look at what we can do to make our datasets easier to use, understand & maintain.
It’s frustrating that in Power BI re-naming measures or moving them to another table will break any visuals using them in reports. Likewise, Power BI does not have a feature to hot-swap measures in visuals, to retain formatting or save time. Here I will show you an easy way to replace multiple measures in a Power BI report, including those used in “broken” visuals. Fix all broken visuals in Power BI reports using this method!
A quick tutorial about how to add or modify static data tables (i.e. those created with Enter Data) using Tabular Editor 2 or 3.
If you want to learn Tabular Editor, this is a good place to get started. This is a walk-through of some basic settings and uses of the tool, including how to find your way around and customize the user interface, and create, modify and organize objects in the model.
The default Cards & KPI visuals are frequently the first visual a report user will see. It is thus important that they contain meaningful values. Unfortunately, for many users, a (Blank) is not meaningful, either because it is not understood, or they expect to see 0, instead. Here I explain how you can easily hide these blanks with conditional formatting, or a few methods to replace the (Blank) with 0.
Tabular Editor (TE) is a powerful, high-quality, external tool for Power BI & AS Tabular Models that helps you make better models more effectively. Since adopting TE in my Power BI workflow, time on dev tasks has been reduced ~60% compared to when I used Power BI alone. What is this tool, exactly, and how can it help us develop better Power BI data models?
In this article we look at how to format all DAX in Power BI datasets at once. With the push of a button your DAX will be formatted using these C# scripts! Save them as macros and never waste time formatting again.
In this article we look at a method for creating waffle charts in Power BI with the default visuals.
In this article, we look at a method to format a single data point in a Power BI visual. Specifically, we look how to label the latest data point in a line chart. This method also works with individual formatting of other data points.
