Dynamic "Column" Headers for Time Periods in Power BI

Video by: Reid Havens

Learn how to leverage DAX Calculated Columns to create dynamic time period names - that can then be used in the columns well of a matrix table to create dynamic column header names.

Automatic Anomaly Detection for Line Charts in Power BI

Video by: Reid Havens

Learn about the automatic anomaly detection feature for line charts. This feature can be enabled from the analytics pane for line visuals in Power BI desktop.

Check out our Google Analytics Report where this feature is showcased!

Formatting All [DAX] Measures at Once with Tabular Editor

Video by: Reid Havens

Learn how to leverage Tabular Editor automation to easily format all the DAX measures in your Power BI (PBIX) model. Two versions of the format code is provided below. For developers using version 2.13 or later. There is a faster and more secure function in Tabular Editor to use now. For people running the earlier versions of Tabular Editor, the previous function (show in the video) is still provided. It is recommended though to download and use TE 2.13 or later for best results.

CODE SNIPPET (WHEN USING 2.13 OR LATER)

Model.AllMeasures.FormatDax();

CODE SNIPPET (WHEN USING EARLIER VERSIONS)

foreach (var m in Model.AllMeasures) { m.Expression = FormatDax(m.Expression); }

RELATED CONTENT

Tabular Editor Format DAX Functions
Show DAX Measures in Description Tooltip
PowerBI.tips Business Ops

Showing DAX Expressions When Using Power BI Datasets (Live)

Video by: Reid Havens

Learn how to display DAX expressions in the description tooltip - when hovering over the measure in the fields list. This can be applied to all measures easily and effortlessly using Tabular Editor.

Related Content

External Tool - Tabular Editor

External Tool - DAX Studio

Code Snippet

foreach (var m in Model.AllMeasures) { m.Description = m.Expression; }