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); }

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.

Code Snippet

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

Posted on November 3, 2020 by Reid Havens and filed under External Tools, Data Modeling, Intermediate and tagged Data Modeling Beginner DAX Tabular Editor.

Using the Bullet Chart Visual to Show Total Comparisons on Tooltips

Video by: Reid Havens

Learn how to leverage the bullet chart visual to display comparisons between values and different totals or sub totals - within tooltips in Power BI.

Download Report From The Blog Files Page

Posted on October 27, 2020 by Reid Havens and filed under Beginner, Intermediate, Visualizations, DAX and tagged Tooltip Custom Visuals Beginner DAX.