(Livestream Replay) Making a Real Report Fully Bilingual: Harder Than you Thought! - with Bernat Agulló

DESCRIPTION 📄

Translating a model metadata does almost nothing in the direction of translating a real report. Translating the data is necessary, and you need to be able to translate titles and display names, even those coming from field parameters. Different strategies are needed to translate the different bits of the model and bring it back to the report so that with a single click everything changes the language. It's a lot of work.

GUEST BIO (Bernat Agulló)👤

Bernat is an enthusiast Power BI developer from Barcelona, part-owner of Esbrina and Data Platform MVP since 2022. He blogs mostly about calculation groups and Tabular Editor C# Scripting, but also about challenges he has found as a consultant. One of his latest challenges has been making a Japanese-only report turn into an English-Japanese report. Other recent highlights include modifying the report layer with a c# script or integrating Visual Studio and VS code with Tabular Editor to leverage GitHub Copilot to author C# Scripts.

RELATED CONTENT 🔗

Blog
LinkedIn
YouTube
GitHub
Bilingual Report Part 1
Bilingual Report Part 2

(Livestream Replay) Building Income Statements in Power BI - with Chris Barber

DESCRIPTION 📄

Profitability is a key metric for any business, as profits can be distributed back to shareholders either directly or indirectly. An income statement—also known as a Profit and Loss (P&L) statement—answers high-level questions such as “What was our net profit last year?” while summarizing key revenue (e.g., product revenue) and expense (e.g., R&D) items.

Unlike static reports, a P&L semantic model provides granular detail, enabling users to explore insights such as “How was R&D spending distributed across projects, fiscal periods, or legal entities?” With a well-structured model, users can analyze financials dynamically through Power BI reports, PivotTables, and Excel formulas.

GUEST BIO 👤

Chris Barber is a Chartered Accountant (ACMA, CGMA), four-time Microsoft MVP, and author of Income Statement Semantic Models. He runs StarSchema.co.uk and has created popular YouTube videos (100K+ views) and courses (1K+ participants) focused on building Profit and Loss (P&L) reports in Power BI.

RELATED CONTENT 🔗

Website
Linkedin

Fixed-Window Charting in Power BI: Auto-Adjusting Calendar Periods

Video by: Reid Havens

Learn how to create a chart that always displays the same number of calendar periods, driven by slicer period selection, and regardless of if there is existing data (yet) for a period. This leverages a [DAX] generated table, relationships, and some auto-magic features. Tune in to learn more!

RELATED CONTENT 🔗

Creating a MTD/QTD/YTD Time Intelligence Slicer

(Livestream Replay) AI Assistant for Tabular Editor - Andrzej Leszkiewicz

DESCRIPTION 📄

Discover how to enhance your Power BI workflow with Tabular Editor and the OpenAI API. This presentation demonstrates how, with a few simple C# scripts, you can directly access the OpenAI API from Tabular Editor to create a custom AI assistant with full access to your Power BI report’s data model—including tables, columns, relationships, measures, calculation groups, and more. Use this assistant to comment on DAX code, generate model documentation, write measures, and more, harnessing the full power of the latest OpenAI models—all without the need for Power BI Premium or Fabric capacity. An OpenAI API subscription is required, and Tabular Editor 3 is necessary.

GUEST BIO (Andrzej Leszkiewicz) 👤

Andrzej is a Power BI and data visualization developer and consultant, data explorer, explainer, and visualizer. He creates highly customized, interactive visualizations using the Vega visualization grammar and Deneb. Andrzej has introduced IBCS-styled data visualizations, embedded into Power BI's built-in Table, Matrix, and Card visuals. An IBCS® Certified Analyst, he is a passionate advocate of IBCS standards. With a background as an IT project manager and CIO in non-IT companies, Andrzej has been a full-time independent freelance Excel and VBA developer and consultant since 2011, focusing entirely on Power BI and data visualization since 2020. Through his YouTube channel, LinkedIn, and other social media, Andrzej shares his knowledge and passion for data visualization and related topics.

RELATED CONTENT 🔗

Tabular Editor
Open AI API
Andrzej's Youtube
Andrzej's LinkedIn
Andrzej's Blog
Andrzej's GitHub