Category: Tabular Editor

Single-letter month/weekday labels with Group By Columns

Background In the SQLBI article Understanding Group By Columns in Power BI, Marco Russo & Alberto Ferrari show how the Group By Columns property allows the values in one column to be “grouped by” unique key values defined by one or more other columns, rather than by the original column’s unique values. For example, setting…

Field parameters in Analysis Services models

If you have ever created a Power BI report with live connection to an Analysis Services Tabular model (SQL Server Analysis Services or Azure Analysis Services), you might have wondered if it is possible to use field parameters in such a report. The answer is yes! The main point to remember is that field parameters…