Webinars and Video Gallery topics

Report Design Studio: design a Power BI theme and page layout on a live report (free)

benibix — Mon, 02 Nov 2026 17:36:49 GMT

Hi everyone,

Making a report look good in Power BI usually means formatting every visual by hand, writing a theme JSON in a text editor, and hoping the colours are readable for everyone. I wanted one place to do all of it on a live report, so I built Report Design Studio. It's free, it runs in your browser, and there's no account: tools.benibix.com/data/report-design-studio

Watch it

Short overview video: the whole tool in a few minutes
Report Design Studio playlist: step-by-step lessons, from your first theme JSON to an accessible, fully styled report

Here is what it does, and at the end there's a sample theme you can make in one click.

1. Colour, four ways

Palettes: 65 curated palettes, including colour-blind-safe sets such as Okabe–Ito and Paul Tol
Harmony: generate a palette from one base colour
Extract: pull a palette out of an image, such as your logo (read in your browser, never uploaded)
Build: set every colour by hand, lock swatches, and make sequential or diverging ramps

2. Every visual, all at once or one at a time

Simple mode styles every visual together: borders, corners, shadows, padding, gridlines, data labels and legends
Advanced mode styles one of 27 visuals at a time, including buttons and shapes in their hover, selected and pressed states, plus the report wallpaper and the filter pane
One font for the whole report, and the preview shows the visual you are editing

3. A page layout, not just a background

Navigation (an icon rail, a sidebar, a floating sidebar or a top bar), a title bar, a slicer panel, sections of tiles and a footer
8 starters and 7 page sizes, for Power BI, Tableau, Looker Studio and Full HD
Download it as a PNG page background, a layered SVG or Copy for Figma (every zone a named layer), or one PowerPoint slide of editable shapes

4. Readable for everyone

Every colour is checked on its own visual's card against the WCAG 3:1 floor for chart marks (1.4.11), with APCA shown beside it
A matrix flags colour pairs people could confuse
See the live report with protanopia, deuteranopia, tritanopia or in greyscale
One click nudges failing colours until they pass, keeping them apart from each other

5. Export, import and share

Theme JSON, checked against the Power BI theme schema before it downloads, so Power BI won't reject it
A matched dark and light pair, a swatch sheet PNG, and design tokens as CSS variables, SCSS variables or Figma and W3C tokens
Import an existing theme JSON to edit it. Settings the studio doesn't edit are kept and written back into the export
Share a link that holds the whole design in the address itself, or save presets in your browser. Undo and redo work as you'd expect

Everything runs in your browser. Images, imported themes and exports never leave your computer.

Free sample: the Deep Space theme

To show the result, here is Deep Space, the dark theme in the pictures. To get it, open the studio, pick Deep Space under Palettes, and choose Export, then Theme JSON.

8 data colours: #B18AF4, #F7B340, #22B1F2, #8CD817, #6A94F1, #FAA8B6, #14B8A6, #E4C9FC
Every data colour is at least 5.7:1 against the card (WCAG asks 3:1 for chart marks), and the text is 13.8:1
Good, neutral and bad colours for conditional formatting, card borders with 8 px corners, and Segoe UI throughout

To use it: in Power BI Desktop, go to View, then Themes, then Browse for themes, and pick the file.

I'd like your feedback

What's missing for your reports? Is there a visual you style by hand every time, or an export you'd want? I read every comment, and I'll build what comes up most.

Power BI last year compares the wrong weekday? (Tiny Fix 8)

ravi326 — Sat, 31 Oct 2026 15:15:14 GMT

If your last-year measure uses SAMEPERIODLASTYEAR on a date column, Power BI compares each day with the same date last year, not the same weekday. 7 March 2026 is a Saturday, but 7 March 2025 was a Friday, so every day is compared with the wrong weekday.

The recommended way is calendar-based time intelligence (preview). A calendar compares by week, so the Saturday of week 10 meets last year's week 10 Saturday:

File, Options and settings, Options, Preview features: select Enhanced DAX Time Intelligence, then restart Power BI Desktop.
In the Data pane, right-click your Date table, then Calendar options, New calendar.
Year = Week Year, Week = Week, Date = Date. Validate data, then Save and close.
Point every last-year measure at the calendar: SAMEPERIODLASTYEAR ( 'Retail weeks' )

Check: before, Saturday +127% and Monday -50%. After, every day lands between +7% and +15%, and the bars line up.

Trap from my test: start the date table on the Monday that begins week 1 (30 Dec 2024 for 2025). Mine started on 1 January and every comparison slipped by two days. Calendars don't work with live connected or composite models yet.

Microsoft Learn: https://learn.microsoft.com/power-bi/transform-model/desktop-time-intelligence

Why does my Power BI slicer show items with no data? (Tiny Fix 7)

ravi326 — Tue, 27 Oct 2026 13:48:57 GMT

Pick North in a Region slicer and the Product slicer still lists all 10 products, even the 4 that North never sold.

Why: a slicer lists every value in its own table, and the relationships filter one way, into Sales, never back.

Microsoft advises against switching the relationship to Both for this. Filter the slicer instead:

Click the Product slicer and open the Filters pane.
Drag your measure (Total sales) into Filters on this visual.
Under Show items when the value, pick is not blank, then Apply filter.

Check: before, 10 products. After, only the 6 that North sold.

Microsoft guidance: learn.microsoft.com/power-bi/guidance/relationships-bidirectional-filtering

Fabric IQ MCP: Connect Power BI to Claude Code (Full Setup + Real Demo)

ravi326 — Fri, 09 Oct 2026 06:23:15 GMT

Connect Claude Code to a Power BI semantic model with the Fabric IQ MCP server, step by step: sign in, install Skills for Fabric, check the connection, and work around one Claude Code gotcha. Then a real investigation on a retail model, from "sales are down" to one product and its supplier, plus a row-level security check with a Viewer account. Every command is in the description.

AI‑Powered Report Migration: Tableau to Power BI Part 2

ribisht17 — Tue, 06 Oct 2026 05:52:25 GMT

Can Claude AI actually migrate a Tableau workbook to Power BI?

I tried it on a real file—calculated fields, a Rank table calc, a Top 3 filter, and a dual-axis Sales/Profit chart—and I'm showing every step, including the parts that broke and how they got fixed. The honest technical breakdown: Claude's live MCP connection to Power BI Desktop builds and validates the semantic model—tables, M queries, and DAX measures—in real time. It CANNOT touch report visuals; that's a hard architecture limit. Getting the actual charts built needs a second mechanism: saving as a PBIP project, zipping it, and having Claude edit the report JSON files directly.

Copy selected cells from Power BI to Excel with a custom table visual

theBItoolbox — Fri, 02 Oct 2026 20:20:57 GMT

Sometimes you only need a few cells from a Power BI report for a quick check, calculation, or follow-up in Excel.

In this video, I demonstrate an Excel-style copy-and-paste workflow using Advanced Grid Table, a custom Power BI visual I developed.

The workflow is straightforward:

Select a range of cells in the visual.
Copy the selection.
Paste it into an Excel worksheet.

This can be useful during report reviews and meetings when someone needs to work with a specific set of values.

The demonstration uses the Advanced Grid Table custom visual.

Watch the demonstration:
Copy Selected Cells from Power BI to Excel

Project on GitHub:
Advanced Grid Table — files and documentation

When your report users move data into Excel, do they usually need the entire table or just a selected range?

Power BI Financial DAX Functions Explained | ODDFPRICE, ODDFYIELD, ODDLPRICE & ODDLYIELD

suparnababu8 — Sat, 19 Sep 2026 04:06:48 GMT

In this video, you'll learn four advanced Financial DAX Functions with practical, real-time business examples.

✅ ODDFPRICE

✅ ODDFYIELD

✅ ODDLPRICE

✅ ODDLYIELD

If you find this video helpful, please Like, Share, and Subscribe to the NDAC Channel for more learning content.

TBILLPRICE, TBILLYIELD & TBILLEQ in Power BI DAX | Financial DAX Functions Explained

suparnababu8 — Sun, 06 Sep 2026 14:52:28 GMT

In this video, you'll learn three important Financial DAX Functions in Power BI:

✅ TBILLPRICE

✅ TBILLYIELD

✅ TBILLEQ

Using practical business and finance scenarios, I explain how these functions help calculate Treasury Bill prices, yields, and bond-equivalent yields directly within Power BI.

Whether you're a Power BI Developer, Data Analyst, Financial Analyst, or someone preparing for Microsoft Power BI interviews, this tutorial will help you understand these financial functions with ease.

Show Values Inside a Power BI Donut Chart 🎯 August 2026

amitchandak — Thu, 03 Sep 2026 15:33:53 GMT

Power BI Donut Charts just got a useful upgrade.

In the Power BI August 2026 update, you can now show a value directly in the center of a Donut Chart without needing to overlay a separate Card visual.

Center value for Donut Chart (Generally Available)

Donut charts can now display a value in the center. Enable the center value option and it shows up right in the middle.

You control the details in the formatting pane: value format, display units, and font. You can add an optional label above or below the value, place an image above or below it, or change the background fill or image of the center. If you need something other than the total, just add a custom measure to the center value in the formatting pane.

The center value stays in sync with your data. Filtering, cross-highlighting, drill-down, and selecting a slice all update it automatically. And because it lives inside the visual, it stays aligned when you resize the report, view it on mobile, or open it on a dashboard. It also works with screen readers.

To add a center value, select your donut chart, open the formatting pane, and turn on Center value.

Is Power BI Dead? Is Microsoft Fabric only a Data Analytics platform?

amitchandak — Mon, 31 Aug 2026 08:06:29 GMT

Microsoft Fabric is known for Data Engineering, Data Warehousing, Data Science, Real-Time Analytics, and Power BI. But with Fabric Apps, there's more to think about beyond traditional analytics.

In this video, I show how to create a Microsoft Fabric App using the Rayfin SDK and how modern development tools can be used to build interactive applications directly around your Fabric data.

Here's what we cover:

What are Microsoft Fabric Apps?

Introduction to the Rayfin SDK

Exploring the Fabric App user interface

Developing a Fabric App using Visual Studio Code

Using GitHub Copilot for AI-assisted development

Building a reporting experience inside a Fabric App

Creating a Data Entry Sales Application

Adding a Semantic Model experience to the same application

And finally, the big question: Is Microsoft Fabric becoming more than a Data Analytics platform? And is Power BI dead? 👀

MDURATION, PDURATION & NPER in DAX | Financial Functions with Real-Time Examples

suparnababu8 — Tue, 01 Sep 2026 18:23:25 GMT

In this Power BI DAX tutorial, learn how to use MDURATION, PDURATION, and NPER financial functions with practical real-world examples.

Whether you're preparing for Power BI interviews, working in financial analytics, or improving your DAX skills, this video will help you understand these advanced financial DAX functions clearly. Subscribe for more Power BI, DAX, Microsoft Fabric, Data Analytics, and Business Intelligence tutorials.

Claude Built My Power BI Dashboard. Here's how.

ribisht17 — Tue, 18 Aug 2026 17:53:10 GMT

I sketched a rough wireframe of a dashboard I wanted—no DAX, no data model, just a layout idea. Then I handed it to Claude AI connected to Power BI Desktop through MCP and watched it build the actual dashboard: creating the semantic model, writing every measure from scratch, and turning a static sketch into a working, interactive report. This is the wireframe-to-dashboard workflow in full — how Claude reads a visual mockup, maps it to real fields and calculations, and produces DAX measures on its own without me writing a single line.

COUNT vs COUNTA vs COUNTX in Power BI DAX | Aggregation Functions | Episode 2

ajaybabuinturi — Wed, 29 Jul 2026 06:19:18 GMT

In this episode, we take a deep dive into three essential DAX counting functions:

✅ COUNT()

✅ COUNTA()

✅ COUNTX()

Using multiple practical examples and real-world business scenarios, you'll learn

🔹 How COUNT(), COUNTA(), and COUNTX() work in Power BI DAX

🔹 The key differences between these three functions

🔹 When to use each function in real-world reporting scenarios

🔹 Step-by-step demonstrations with practical datasets

🔹 Best practices to write efficient and accurate DAX formulas

watch?v=i3hSzbTYcFQ

Power BI DAX Financial Functions Explained | RATE, INTRATE & RECEIVED

suparnababu8 — Thu, 20 Aug 2026 13:54:57 GMT

In this video, you'll learn three important Financial DAX Functions in Power BI with practical business examples and step-by-step demonstrations.

✅ RATE Function – Calculate interest rates for loans and annuities
✅ INTRATE Function – Determine the interest rate earned on fully invested securities
✅ RECEIVED Function – Calculate the maturity value received from discounted securities

watch?v=WDwYz-oGcV4?si=7sO1r1A0F9y05Rz4

AVERAGE, AVERAGEA & AVERAGEX in Power BI DAX | Aggregation Functions Episode 1

ajaybabuinturi — Fri, 17 Jul 2026 04:32:27 GMT

In this video, we begin our new playlist dedicated to mastering DAX Aggregation Functions in Power BI. First, we explore all the aggregation functions available in DAX and then deep dive into three important functions:
✅ AVERAGE()
✅ AVERAGEA()
✅ AVERAGEX()

watch?v=Om-M_qU03dY?si=VmUZ7q2DU21_gyNT

Power BI DAX Financial Functions Explained | YIELD, YIELDDISC & YIELDMAT with Examples

suparnababu8 — Fri, 17 Jul 2026 04:19:43 GMT

In this video, we explore three important Financial DAX Functions used in bond and investment analysis:

✅ YIELD
✅ YIELDDISC
✅ YIELDMAT

Subscribe for more Power BI, DAX, SQL, Microsoft Fabric, and Data Analytics content.

watch?v=UBsXBzkYUcA?si=glupoEmS8SZvhZS5

Stop Documenting Power BI Manually: 5 Claude AI Hacks

ribisht17 — Tue, 18 Aug 2026 17:48:52 GMT

Claude AI + Power BI (via MCP)

Claude AI can now:

Read your Power BI semantic model
Audit your DAX
Create new measures
Query your data live

⚡ In this video: the 5 highest‑value things to do right after connecting Claude to Power BI, demonstrated on a real, messy, production‑style model.

You’ll see Claude:
- Auto‑document an entire model in ~90 seconds
- Catch real DAX errors (divide‑by‑zero, duplicated measures)
- Write and insert a Sales YoY Growth % measure with proper blank‑handling
- Answer data questions with live DAX queries—no visuals needed
- Flag relationship problems that silently produce wrong results
  
  👉 Which one are you trying first?

watch?v=V-1er3Q_lrQ

PL-300: Building Interactive Dashboards and Data Alerts in Power BI | Ilgar Zarbaliyev

Ilgar_Zarbali — Mon, 06 Jul 2026 14:33:17 GMT

In this free virtual session, you'll learn how to build interactive Power BI dashboards and set up automated data alerts to monitor your data in real time — a must-know skill for the PL-300 exam and real-world business reporting.

📌 This session is part of the Azerbaijan Data & AI Meetup Group's 6-session PL-300 study series, hosted as part of Microsoft's Data Days 2026 global learning initiative.

🧠 What you'll learn:
✅ How to build interactive dashboards in Power BI
✅ How to use slicers, drill-throughs, and bookmarks for interactivity
✅ How to set up Data Alerts to monitor key metrics
✅ How to configure alert thresholds and notifications
✅ PL-300 exam tips for this topic

watch?v=nxVFcqaJvBs

PL-300: Row-Level Security in Power BI | Ilgar Zarbaliyev

Ilgar_Zarbali — Mon, 06 Jul 2026 14:31:16 GMT

In this free virtual session, you'll learn how to restrict data access for different users within the same Power BI report using Row-Level Security (RLS) — a must-know skill for the PL-300 exam and real-world enterprise reporting.

📌 This session is part of the Azerbaijan Data & AI Meetup Group's 6-session PL-300 study series, hosted as part of Microsoft's Data Days 2026 global learning initiative.

🧠 What you'll learn:
✅ How to set up Row-Level Security (RLS) in Power BI
✅ How to create static and dynamic RLS roles
✅ DAX functions for filtering data by user (USERPRINCIPALNAME, LOOKUPVALUE)
✅ How to test and validate roles using "View as Roles"
✅ PL-300 exam tips for this topic

watch?v=SpqKbT-Qpl8

PL-300: Dynamic Currency Conversion in Power BI | Ilgar Zarbaliyev

Ilgar_Zarbali — Mon, 22 Jun 2026 20:30:38 GMT

In this free virtual session, you'll learn how to convert values across multiple currencies dynamically using real-time exchange rates and powerful DAX calculations — a must-know skill for the PL-300 exam and real-world financial reporting.

This session is part of the Azerbaijan Data & AI Meetup Group's 6-session PL-300 study series, hosted as part of Microsoft's Data Days 2026 global learning initiative.

What you'll learn:

How to set up dynamic currency conversion in Power BI
How to integrate live exchange rates into your data model
DAX calculations for multi-currency reporting
How to build a currency switcher using measures
PL-300 exam tips for this topic

Full session schedule:

Session 1 – June 15: Slicers & What-If Parameters ← you are here
Session 2 – June 22: Dynamic Currency Conversion
Session 3 – June 29: Row-Level Security (RLS)
Session 4 – July 6: Interactive Dashboards & Data Alerts
Session 5 – July 13: AI & Natural Language Features
Session 6 – July 20: Performing Analytics with DAX

Microsoft Data Days official page:
https://community.fabric.microsoft.co...

Like, subscribe, and hit the bell to get notified for every session!

watch?v=L743lZGQtn4