Posts filed under Intermediate

Dynamically Filter Page Navigation Per User With Row Level Security (RLS)

Video by: Reid Havens

Learn how to utilize row level security (RLS) to filter page navigation options for each user by using page navigation buttons and slicer selections in Power BI.

RELATED CONTENT 🔗

Conditional Page Navigation for Buttons in Power BI

(Livestream Replay) Power BI Sidetools External Tool - Didier Terrien

Come hang out as Didier Terrien and I talk about (Power BI Sidetools). Power BI Sidetools is an innovative external tool offering unique features to improve productivity when developing reports, with an impressive list of features and tools contained within! Features such as: exporting data to Excel, transferring DAX and M formulas to files, viewing DAX and M code in Visual Studio Code, preview DAX measures in auto-generated tables, and more!

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
Sidetools Site
Sidetools Support
Didier's Linkedin
Didier's Twitter

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

Fiscal Periods Time Intelligence Slicer in Power BI

Video by: Reid Havens

Part four of four in a series - learn how to leverage relationships and DAX calculated tables to create a time intelligence slicer with fiscal periods in Power BI. The end result will perform faster and create a better user experience versus needing to create many time intelligence DAX measures.

RELATED CONTENT 🔗

Part 1: Creating MTD/QTD/YTD Filters
Part 2: Applying USERELATIONSHIP Function
Part 3: Additional Date Periods

Posted on March 30, 2021 and filed under DAX, Power BI, Slicers & Filters, Intermediate.

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