Havens Consulting
Video by: Reid Havens
Learn how to leverage model tables/columns, and relationships to simplify your DAX code for your Power BI datasets (models), leading to simpler measures, and potentially more efficient (faster) calculations and visual queries. Tune in to learn more!
Video by: Reid Havens
Learn how to leverage C# scripts in Tabular Editor 2 or 3 to create instant Time Intelligence DAX measures off any existing calculations already in your model. This is a huge time savor for applying common date pattern calculations instantly with just a couple clicks in Tabular Editor.
Format All Measures C# Tabular Editor
Benoit Fedit's TE Script
Bernat Agullo's TE Script
Microsoft Power BI Desktop developer mode brings Pro BI developer experiences right into Power BI Desktop and together with Git integration, you can enable seamless collaboration within your development team.
At this session you will learn on how to take advantage of these new tools and features to unblock professional Power BI development experiences within Microsoft Fabric, but also improve your development efficiency by leveraging programmatic generation and editing of content (in a fully supported manner).
Rui is an experienced Microsoft Professional with a deep passion for data and analytics. He has spent the last decade helping companies make better data-driven decisions and is known for his innovative and practical solutions to complex problems.
As a speaker, Rui is engaging, insightful, and highly knowledgeable. He can distil complex data concepts into simple, understandable language, and is truly passionate about helping others develop their data skills.
Currently works as Product Manager at the Power BI product team, focusing on Pro-BI experiences.
Rui's Twitter
Rui's LinkedIn
Rui's Github
Developer Mode Guidance
Power BI has a history which has made it challenging to build reports that support multiple languages. Fortunately, enhancements to Power BI over the last year have reduced this challenge making it more attainable to Power BI content creators. As an example, Power BI added support for the USERCULTURE function which provides the ability to write measures which implement report label translations dynamically. Power BI enhancements to the report designer now provide more flexibility to bind measures with dynamic translations to visuals and shapes so they can be surfaced on report pages. Furthermore, the recent introduction of Field Parameters in Power BI now offers a far more elegant and efficient strategy to implement data translations.
In this Livestream session, Ted Pattison will discuss how to get started with multi-language report development. Attendees will learn about the three different types of translations involved with multi-language report development as well as the techniques used to implement them. Ted will demonstrate using the Translations Builder utility to automate repetitive localization tasks that would take forever to complete manually. This session will provide content creators using Power BI Desktop with a better understanding of how all the pieces fit together and with a path forward for building multi-language reports in Power BI using a strategy that is reliable, predictable and scalable.
Ted Pattison worked as an independent trainer and software developer whose community efforts earned him the Microsoft MVP award for 15 years in a row. Ted joined the Power BI Customer Advisory Team (PBICAT) at Microsoft in 2020 where he provides guidance to enterprise customers and ISVs in several areas including developing with Power BI embedding, programming with the Power BI APIs and building multi-language reports.
Ted is also the creator of Power BI Dev Camp (https://www.powerbidevcamp.net) which provides a monthly webinar geared toward professional software developers working with Power BI, Fabric and the Microsoft Data Platform.
Building Multi-language Reports (Guidance Doc)
Building Multi-language Reports (Hands-on Lab)
Building Multi-language Reports (YouTube Video)
Building Multi-language Reports - Part 2 (YouTube Video)
Translations Builder Utility on GitHub
Live Sample of Multi-language Report
Signup for our mailing list to gain access to Power BI files and templates from the videos. You’ll receive a welcome email with a link and password to the Blog Files page.
Reid Havens’ early love affair with analytics has, over the past decade, turned into an evolution into data visualization and report design in Power BI.
Since then Reid has been writing articles and creating YouTube videos to share the word of BI, helping to inspire the next generation of Business Intelligence enthusiasts.
