Topic: Power BI
-
When you create and publish a composite model using DirectQuery for Power BI datasets and Analysis Services, you should pay attention to the minimal permissions required to consume data. For example, consider the following scenario: Base is a shared dataset… Read more
-
Alberto shares his exploration of different techniques for an article about displaying blank as zero in a DAX measure. The article and its video will be much shorter without the trial and error process that you can see without editing… Watch now
-
This article shows how to compute a measure that sums the values produced row by row in the visual into the visual total, instead of recomputing the total value in the filter context of the total. Read more
-
In this article we demonstrate how to use calculation groups to show the behavior of any measure in the last 6 months, starting from a single date selection with a slicer. This can be applied to any number of months. Read more
-
Why the standard DAX time intelligence functions might return unexpected results? Discover how DATEADD and SAMEPERIODLASTYEAR work under the hood! Watch now
-
How to enable cross filter visual behavior in Power BI when using a measure showing Top N and “Other” row? The question came up in a comment to the article https://www.sqlbi.com/articles/filtering-the-top-products-alongside-the-other-products-in-power-bi/ Watch the video to see how we study the… Watch now
-
This article analyzes a classic modeling question: is it better to build a model as a regular star schema or as a single table in Power BI? The answer is clear: a star schema is always the best choice. Read more
-
This short article explains how to change the culture settings of a Power BI Desktop file, which by default corresponds to the locale settings of the machine used to create a Power BI Desktop file. Read more
-
This article shows techniques to obtain a ranking based on more than one column. The ranking can be both static and dynamic. Read more
-
Explore how you can hide columns and tables to Power BI users by using the Object Level Security (OLS) feature released in February 2021. By hiding objects, you also hide derived calculations like measures, calculated columns, and calculated tables. The… Watch now
