Posts filed under Intermediate

[DAX] Dynamic Format Strings WITHOUT Calculation Groups ?!?

Video by: Reid Havens

Learn how to add Dynamic Format Strings for individual [DAX] measures in Power BI! This technique doesn’t require calculation groups or Tabular Editor either, and can be done entirely inside of Power BI desktop.

Side note, if you aren’t using Tabular Editor as a model developer you should be. It’s a fantastic tool for any intermediate to advanced modeling scenarios, and the only way to add calculation groups (today).

RELATED CONTENT 🔗

Dynamic Format Strings in DAX
Kane Snyder’s Linkedin Post
Tabular Editor

Posted on May 30, 2023 by Reid Havens and filed under DAX, Intermediate, Data Modeling and tagged Format Strings Intermediate DAX Preview Features.

Hiding Measures from [DAX] Intellisense!

Video by: Reid Havens

When creating datasets with build permissions (shared datasets), many of us know to hide fields from the data pane. But did you know you can also "hide" measures from the intellisense list in DAX? In this video learn how to use tabular to configure a table property to hide any measures inside of that table, from any DAX intellisense when writing measures. Further increasing usability when creating shared datasets in the Power BI service!

PLEASE NOTE this is not (officially supported) by Microsoft. But is a relatively safe setting to modify. Just be aware Microsoft doesn't provide support for this. More info below at the tabular editor link

RELATED CONTENT 🔗

Data Goblin Report Layer Article
Tabular Editor Private Setting

Posted on April 4, 2023 by Reid Havens and filed under Data Modeling, DAX, Intermediate, External Tools and tagged Tabular Editor.

IBCS Styled Bullet Chart for Native Tables in Power BI!

Video by: Reid Havens

Learn how to utilize an SVG image template to add an IBCS (International Business Communication Standards) inspired bullet chart to your native matrix or table visuals in Power BI Desktop.

RELATED CONTENT 🔗

IBCS Bullet Chart
InfoRiver Matrix (IBCS Certified)

Posted on March 21, 2023 by Reid Havens and filed under Intermediate, Visualizations, DAX and tagged SVG Custom Visuals DAX Intermediate DAX.

Multiple Text Options for Button Navigators in Power BI

Video by: Reid Havens

Learn how to combine button navigators to create a multiple (alternative) button effect options for either the Page or Book Navigator objects in Power BI. This allows for greater customization of a selected vs unselected effect and text display for any active page or bookmark. Tune in to learn more!

Posted on December 20, 2022 by Reid Havens and filed under Intermediate, Bookmarks, Buttons, Design & Presentation and tagged Navigator Buttons Buttons FX Button Color & Formatting Interface & Design.