Topic: Power BI
-
This article provides you with the technical knowledge to choose between using a Date or an Integer to create the relationship between your fact table and the Date dimension. Read more
-
This article shows how to use calculation groups to define a default set of values for columns in your model. Different users can have different default values, and yet retain the full capability to select different values. Read more
-
Convert a “Top N and others” measure pattern into a calculation group that can be applied to any DAX measure in a Power BI model. Watch now
-
This article describes how blank values considered in a DAX conditional expression can affect its query plan and how to apply possible optimizations to improve performance in these cases. Read more
-
DAX Studio 2.16 has two new preview features: Show Debug Commas and Show XMLA Commands. With Show Debug Commas you enable a button to move commas from the end of a line to the beginning of the following line, which… Watch now
-
How to force a measure to return zero instead of blank, in order to highlight combinations of attributes with no data. Watch now
-
Alberto answers a user comment asking how to hide calculation items when too many of them are selected in a report. Explore how we analyze the problem and find possible solutions. Watch now
-
Explore how to create custom groups based on a slicer selection in Power BI. For example, create two versions of a measure: one returns the value of the selected items, and another one returns the value of the other items,… Watch now
-
Learn what happens when you open a PBIX file with Power BI Desktop and why you might wait many seconds with large files. Do you need more RAM or a faster CPU? As usual, it depends, but if you can… Watch now
-
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