Posts filed under Intermediate

IMPROVED Dynamic [DAX] Analytics Lines in Power BI

Video by: Reid Havens

Learn how to prevent a [DAX] error message when setting the Percentile percentage for the Dynamics Analytics Line I showcased back in October.

RELATED CONTENT 🔗

Dynamic [DAX] Analytics Line
DAX Guide - PERTENTILE.EXC
DAX Guide - PERTENTILE.INC

(Livestream Replay) NEW FEATURE for Power BI Side Tools - a DAX Template Generator for Your Reports - with Didier Terrien

Store your favorite DAX expressions into repositories. Share some of them with colleagues or with the community. Find new ones shared by experts and adapt them to your own model in less than one minute. You may even format your DAX, create expressions into your model, and then debug it with the integrated debugger.

DIDIER’S BIO 📄

I worked with data for almost 4 decades in various environments as a developer and project manager. Heavy user of Excel for a long time, I try to move data as much as possible to Power BI since it appeared on the market. Working now as the Group Data Quality Officer in Trescal, my skills cover business and IT areas for the benefit of productivity and quality.

RELATED CONTENT 🔗

Didier's Website
DAX Generator
Sidetools Site
Sidetools Support
Didier's Linkedin
Didier's Twitter

Posted on November 9, 2021 and filed under External Tools, Power BI, Livestreams, Topics & Discussion, Intermediate.

Adding Dynamic [DAX] Analytics Lines to Native Visuals in Power BI

Video by: Reid Havens

Learn how to add [DAX] measure driven values the y-axis constant lines. Allow us to essentially recreate multiple analytics lines that can be configurable by user slicer selections in Power BI.

RELATED CONTENT 🔗

Positive/Negative Line Colors

Creating Date (Calendar) Hierarchy Columns in Power Query

Video by: Reid Havens

Part two of two of my videos on creating a Power Query Calendar Table. In this video we’ll see how to create the necessary date columns needed for dependent and independent hierarchies.

RELATED CONTENT 🔗

Part 1: Creating a Dynamic Range Calendar Table in Power Query

Posted on October 5, 2021 and filed under Power BI, Intermediate, Power Query.