Testing Your Code Using the [DAX] Query View!

Video by: Reid Havens

See some examples on how to leverage the DAX query view to save some of your test code, and staging tables. A great improvement from having to save hidden test and development report pages in your PBIX file. Tune in to learn more!

RELATED CONTENT πŸ”—

Jeffrey Wang Livestream
Working with DAX Query View

Posted on February 6, 2024 and filed under DAX, Power BI Features.

(Livestream Replay) Fabric Lakehouse Hell...or Glory?!? - with Tom Martens

DESCRIPTION πŸ“„

During the last months, we have heard a lot about Microsoft Fabric and how it will change the analytical landscape. How it will help solve the most demanding analytical challenges.

It has become simple to create a lakehouse in seconds, or two, or a hundred. How will we organize our Fabric workspace? Do we have one workspace with three lakehouses (bronze, silver, and gold), or do we have three workspaces? Next to the number of workspaces, what about the capacities? Will a solution β€œown” multiple capacities, or only one or two, and share compute power with other teams, utilizing the idea of the share economy? Here, I want to share some early thoughts, including aspects of data architectures like data mesh and data fabric.

GUEST BIO (Tom Martens) πŸ‘€

Thomas "Tom" Martens has been awarded as an MSFT Data Platform MVP and works as Solution Architect at Munich Re. For 20+ years, Tom delivers Business Intelligence, Data Warehousing, and Analytics solutions. His current interest is in data visualization and applying analytical methods to small and large amounts of data, next to providing the Power BI Platform to users for tackling analytical challenges. Tom is a regular speaker at international conferences and user meetings. Tom is the co-author of the book "Pro DAX with Power BI."

RELATED CONTENT πŸ”—

Website
Twitter
LinkedIn

Posted on February 2, 2024 and filed under Livestreams, Fabric.

Avoiding HIDDEN Visual-Level Filters with Field Parameters

Video by: Reid Havens

Learn how to hide all the visual-level filters from field parameter selections on visuals in Power BI. This addresses a problem where not all the field parameter fields will show at once in the visual-level filter list. Tune in to learn more!

RELATED CONTENT πŸ”—

Field Parameter Doc
Filter Pane Doc

Posted on January 30, 2024 and filed under Reporting, Design & Presentation.

Applying Custom Column Ordering for Field Parameters (Measures)

Video by: Reid Havens

Learn how to override/replace the default Field Parameter sort order in Power BI. This can be very useful when displaying multiple field parameter measures on columns/rows in table or matrix visuals, or anywhere in a visual where you'd want to show multiple field parameter measures at once. Tune in to learn more!

RELATED CONTENT πŸ”—

Field Parameters Doc

Posted on January 23, 2024 and filed under Visualizations, Reporting.