Power BI June 2026 Feature Summary

This month, we’re continuing to focus on making every day work a little easier—whether that’s building reports, modeling data, or just getting answers faster. You’ll see progress across Copilot and newer AI-driven experiences, along with a set of practical updates to reporting that help reduce repetitive work.

As always, there’s a mix of preview and generally available features. Hopefully you find a few things here that make your day-to-day just a bit smoother.

Contents

Download Power BI Desktop

Events and Announcements

Could you be the next Power BI Dataviz World Champion?

The Power BI Dataviz World Championships are back! This is your chance to create something brilliant, learn from the community, and show the world what you can do. Bring your best ideas, push your creativity, and build a Power BI visualization that turns heads. Top contenders won’t just earn bragging rights; they’ll secure a spot at the LIVE finale at FabCon / SQLCon Barcelona this September.

Join us for the kickoff on June 16th. Register now.

Join Us at FabCon Europe in Barcelona

The European Microsoft Fabric and SQL Community Conference take place September 28 to October 1 in Barcelona, Spain, bringing together Microsoft experts and community leaders for exclusive content, live demos, and key announcements, along with more than 130 sessions spanning Fabric, Azure AI, Databases, Power BI, and Microsoft Purview. And of course, the live Dataviz World Championships finale!

The most recent event in Atlanta sold out. Don’t miss out and register for the Barcelona event with code FABCMTY200 to save €200.

Copilot and AI

Fabric Apps for Semantic Models (Preview)

Announced at Build, Fabric Apps introduce a new AI-first way to build custom web apps with Microsoft Fabric as the backend. For analytics teams, this means developers and their AI coding agents now have an accelerated path to building enterprise-grade data apps directly on their semantic models. Organizations can create and deploy operational data apps that leverage the same trusted business logic and the same governance as the rest of their analytics stack.

From financial planning to inventory management to pricing optimization, or really any app you can describe, your coding agent can build a custom-tailored app based on your specifications and semantic model in just a few prompts. And it's not just about polished UI. Coding agents can trivialize features that are used to take real engineering effort, like persona-specific views, custom calendar interfaces, bespoke business logic, and more.

Pause GIF Image.gif

Figure: This is an example Fabric data app on a semantic model for an Opportunity Tracker App.

Copilot in Web Modeling (Preview)

Copilot in web modeling (Preview) rolling out this month in the Power BI service, is an AI-powered assistant helping you analyze and improve your semantic models using natural language so you can spend less time on manual edits

With Copilot in web modeling, you can:

Analyze your model and identify areas for improvement, such as inconsistent naming or unclear structure.
Make schema updates, including renaming tables and columns, creating relationships, and generating DAX measures.

modeling copilot.gif

Figure: Copilot in web modeling running the prompt of “Improve table relationships” and specifying which relationships to create.

This feature is rolling out this month so please stay tuned!

AI-Powered Power BI reporting: From design to deployment with agent skills (Preview)

Power BI Report Authoring agent skills are available to you as part of Skills for Fabric, a first-party catalog of AI agent skills for Microsoft Fabric. Using natural language, users can design, build, validate, and publish Power BI reports without manual file editing or repetitive click-through workflows. Together with a suite of companion skills and the Desktop Bridge, it delivers complete agentic reporting experience.

Capabilities

Build complete reports from a blank canvas or update reports, all through conversation.
Get expert design recommendations grounded in data visualization best practices, tailored to your audience and KPIs.
Go from a vague goal (“I need an executive dashboard”) to a locked, approved report spec with guided Q&A.
See live results instantly - Power BI Desktop reloads and captures screenshots automatically for review.
Publish finished reports directly to any Microsoft Fabric workspace from the terminal.
Download, update, or manage published reports without leaving the command line.

End-to-End Reporting Workflow

The pipeline is fully orchestrated through natural language across five coordinated stages:

Plan - Gather requirements, define audience, and lock a report specification.
Design - Select page archetypes, chart types, color palettes, and accessibility standards.
Author - Generate report definition files (pages, visuals, filters, themes).
Validate - Reload Power BI Desktop and capture screenshots for visual review.
Publish - Deploy the finished report to a Fabric workspace.

Figure: Power BI agentic reporting workflow.

Data answering available in Fabric Skills, Cowork & M365 Chat (Frontier)

A key part of our vision for Fabric IQ is meeting users where they already are and bringing them the data insights they need to make better business decisions. Instead of creating another destination, Fabric IQ shows up inside the platforms where work is happening every day.

The new Fabric IQ skill provides a centralized way to support end-users chatting with their data. Initially, this skill supports consumer data discovery and answers from Power BI reports and semantic models, but over the coming months, we’ll expand to support Fabric data agents and ontologies (and through those workloads, the full breadth of OneLake). This skill is available as a part of Agent Skills for Fabric and powers a breadth of experiences.

At the same time, Fabric IQ is integrated into M365 Copilot Cowork, extending these capabilities to a broader set of business scenarios. When the Fabric IQ plugin is enabled in Cowork, users can interact with their data as part of their everyday work—whether they are preparing for a review, tracking progress, or exploring trends. Instead of navigating reports, they can simply ask and get clear, contextual answers grounded in trusted Power BI models.

And finally, M365 Copilot Chat will also use Fabric IQ to enable business users to ask data questions in mainline Copilot. This will enable Copilot users to chat with their data, bringing Power BI data into Copilot’s context to more effectively and holistically answer questions about your business. Power BI data answering is available now in M365 Copilot to Frontier users.

Under the hood, Fabric IQ connects directly to existing Fabric and Power BI investments. It respects the user permissions, uses the same semantic models, and ensures answers remain consistent with what users see in reports. This makes it a natural extension of the governed data ecosystem, not a separate or disconnected layer.

What this unlocks is a shift from navigating reports to having conversations with data. Questions that once required multiple steps can now be answered in a single interaction, making it easier for more people to engage with data and contribute to decisions.

The Fabric IQ consumption skill is also an example of how enterprise data can participate in a broader ecosystem of intelligent agents and extensible experiences. By showing up across all these surfaces, it establishes a pattern for bringing governed data into any surface where users are already working.

This is the direction we are continuing to build toward: reducing friction, expanding access, and enabling teams to move faster with data—right in the workflow.

Reporting

Shape map (Generally Available)

Use built-in maps, upload your own custom TopoJSON or GeoJSON files, or reference maps directly via URL. If you upload a custom map, you can now download it later to make edits and re-upload—no need to track down your original file. The color formatting pane has also been updated to show the relevant options based on your Shape Map configuration, making it easier to find and apply the settings you need.

Figure: Shape Map in Power BI showing built-in and custom map support, with options to upload, download, and format maps based on the current configuration.

Date picker for slicers (Preview)

The new Date picker option for slicers eliminates the recurring task of manually updating date slicers each reporting period. Set a relative selection then publish and it automatically rolls forward as your data refreshes. Your report viewers are not locked into this selection; they are free to choose their own relative or manual options, selecting a range or a single date from a calendar or slider.

To try it, enable the preview in Options > Preview features, then add a date column to a slicer and select the Date picker option.

Save time on report maintenance: No more revisiting reports every month, quarter, or year to update date selections.
Give report viewers full flexibility: Publish with a relative default, and your report viewers can easily switch to any manual range or single date using a single calendar or slider—without needing a separate slicer.
Keep selections data-aware: Relative options anchor to today, the first date, or the last date of your actual data, so selections stay meaningful as data changes.
Reduce confusion: The compact visual clearly displays the current date range and selection summary, with indicators when a selection falls outside available data.

Figure: Date picker slicer in Power BI showing relative and manual date selection options in a single control.

Auto-expand options for matrix row and column headers (Generally Available)

The matrix visual now includes auto-expand settings for both row and column headers, letting you control whether new hierarchy levels appear expanded or collapsed by default. When Auto expand is turned on, any new rows or columns added to the matrix automatically display in their expanded state, showing all levels of detail without requiring users to manually expand each one.

This is especially helpful for reports that use Personalize this visual, where report viewers can add their own fields to the matrix—with auto-expand enabled, those newly added fields display their full hierarchy immediately. Previously, new hierarchy levels defaulted to collapse, which meant users had to click through each level to see the data they added.

You can configure this setting separately for rows and columns by toggling Auto expand in the Column headers or Row headers sections of the format pane.

Figure: Matrix visual auto-expand setting for row and column headers, showing how newly added hierarchy levels can appear expanded by default.

Scatter charts: Auto-fit markers

Scatter charts now include an Auto-fit markers option that automatically adjusts the plot area so markers and bubbles near the edges and corners remain fully visible. You no longer need to manually or dynamically adjust min/max axis ranges to prevent clipping.

Figure: Auto-fit markers toggled on and kept the markers from being clipped at the edges of the scatter chart.

Axis improvements for bar and column charts (Generally Available)

You now have more control over how axes display in bar and column charts. A new Rounded range option lets you remove extra axis padding by turning it off, so the value axis starts flush with your data—useful when you need a tighter visual without gaps. Additionally, adding data labels no longer shifts the axis range, so your axis stays consistent whether data labels are on or off.

Figure: Round range option to turn off and reduce padding between the bars and the axis.

Card visual image hover state options (Generally Available)

The card visual now supports hover states for the image element, giving you more control over how your reports respond to user interaction. With this update, you can configure different image settings—such as a different image source, transparency, effects, or background color—that appear when users hover over a card. This lets you create reports that feel more dynamic and responsive, helping users understand that cards are interactive or highlight important information when attention is focused on a specific metric.

To configure hover states, select a card in the format pane, choose Hover from the States dropdown, and customize your image settings.

Figure: Card visual with image hover state options, showing how image source, transparency, effects, and background color can change on hover.

Slicer visual selection icon color formatting (Generally Available)

The slicer visual now lets you customize the selection icon color, making it easier to create slicers that work with dark backgrounds. Previously, selection icons, the check box or radio buttons, used a fixed color. With this update, you can choose a color that contrasts with your slicer's background, ensuring selection states remain clear and accessible. This change is especially useful for reports that use dark themes or need to match specific brand colors, giving you full control over the slicer's appearance without sacrificing usability.

To configure this setting, select your slicer, expand Selection icon in the format pane, and choose your preferred color.

Figure: Slicer visual selection icon color formatting, showing how the check box or radio button color can be customized for better contrast and theming.

Matrix and table fixed width conditional formatting (Generally Available)

The table and matrix visuals now support conditional formatting for custom column widths, letting you dynamically control column sizing. This update gives report authors tools to let report users adjust column widths themselves in creative ways. By binding column width to a What-If parameter and adding a button or slider, you can give users direct control over how much space each column takes—useful when different users need to emphasize different data or when screen sizes vary.

To configure conditional formatting, enable Custom widths in the Column width section of the format pane, then select the fx button next to any column to set your formatting rules.

Figure: Matrix and table custom widths conditional formatting, showing how column widths can be dynamically controlled using formatting rules.

Azure map selections on by default (Generally Available)

The Azure Maps visual now has selection controls turned on by default, making it easier for report users to select multiple data points directly on the map. The selection toolbar gives users several ways to select geographic areas: draw a circle or rectangle around locations, use a polygon (lasso) tool for freeform shapes, or select areas based on travel time or distance from a point.

To complete a polygon selection, users can click the first point again, double-click the last point, or select the C key. Users can select groups of locations at once and filter other visuals based on the selected area. Previously, this capability was available but turned off by default, which meant many users never discovered it. With this change, the selection tools appear in the map toolbar automatically, so users can start selecting regions immediately without any configuration. This improvement helps users explore geographic data more intuitively, whether they're analyzing sales by region, identifying clusters, or comparing performance across territories.

Report authors who prefer the previous behavior can disable shape selection by turning off the Selection toggle in the Controls section of the format pane.

Figure: Azure Maps visual with shape selection enabled by default, showing toolbar controls for selecting multiple locations using circles, rectangles, or freeform shapes.

Tooltip options for Power BI visuals (Generally Available)

Configure tooltips to not only show the data values but also explain it. No DAX measure needed. Tooltip options in the format pane include showing only the fields specified as tooltips in the build pane and crafting any sentence to add the tooltip. This sentence mode also lets you refer to the tooltip fields to let you explain the data instead of or with the fields listed. This gives you more control over the information viewers see when hovering over data points and is a step between the default tooltips shown and crafting a fully customized page for the tooltips.

Figure: Configure tooltip sentence mode in the formatting pane.

Modeling

DAX user-defined functions (Generally Available)

UDFs let you define a calculation once and reuse it across measures, calculated columns, and visual calculations. As first-class model objects with typed signatures, they bring structure and consistency to your DAX logic. You can also save function definitions as TMDL files and store them in Git-integrated workspaces, enabling teams to share and consume approved business logic from a single source of truth.

Capabilities

Web modeling: View and edit DAX UDFs in the browser with the same convenience as in Power BI Desktop. This allows teams to collaborate on function development and updates directly from any device, streamlining the authoring and maintenance process.
Optional parameters: Specify a default expression for a parameter in the function signature to make a parameter optional. A UDF has the following grammar:

FUNCTION <FunctionName> =
    ( [<ParameterName> [: [<Type>] [<Subtype>] [<PassingMode>]]
        [= <DefaultExpression>], ...] )
        => <FunctionBody>

For example, given the following function using optional parameters:

FUNCTION AddNum = (x : NUMERIC = 1, y : NUMERIC = 2) => x + y

One can invoke AddNum(), AddNum(1), AddNum(,2) or AddNum(1,2). If the caller omits the argument, the default expression is used as the argument value. The default parameter expression will respect type hints at runtime and can invoke other UDFs or built-in functions.

A range of type hints is supported to offer expressiveness, flexibility and runtime type safety. Supported type hints are: AnyVal, Scalar, Table, AnyRef, CalendarRef, ColumnRef, MeasureRef, TableRef.
Create and edit UDFs in Model View in Power BI Desktop: Use “New function” on the context menu to get started and then use the formula bar to modify the UDF expression.
DAX UDF expressions saved in the model are kept in sync when you rename tables, columns, or measures. Object dependencies are tracked automatically.
The new TABLEOF and enhanced NAMEOF DAX functions simplify referencing underlying tables and object names when authoring UDFs.
INFO.USERDEFINEDFUNCTIONS DMV: Returns a table with details about each UDF in the semantic model.
SQL Server Management Studio (SSMS): UDFs are supported starting from version 22.5. You can script, create, and update UDFs using SSMS, although syntax highlighting for UDFs is not currently available in SSMS.

To get started, open a semantic model in Power BI Desktop or Power BI Service and add a function from Model View.

DAX query view results gird with filtering and sorting (Generally Available)

The DAX query view result grid now includes sort and filter controls, making it easier to explore query results without modifying your DAX code. Each column header displays a sort icon that lets you quickly toggle between ascending and descending order with a single click. For more options, select the ellipsis (...) on any column header to access additional controls: clear the current sort, search for specific values, or filter the results by selecting which values to include.

These controls help you validate query output faster—you can sort to find the highest or lowest values, filter to focus on specific segments, or search for records, all without rewriting your query. This is especially useful when debugging DAX expressions or exploring unfamiliar data, since you can interactively narrow down results to understand patterns or identify issues.

Figure: DAX query view results grid with sorting and filtering controls, showing how users can sort columns, search values, and filter results directly in the grid.

Developers + API’s

Power BI Enhanced Report Format (PBIR) Default-On update

In January 2026, we announced that PBIR would become the default Power BI report format, starting with the Power BI service and followed by Power BI Desktop. As the default-on rollout expanded to a broader set of reports, we encountered issues that required us to pause the rollout, which is why PBIR was not enabled by default in the service.

PBIR is the future of Power BI report code format

These pauses in the default-on rollout do not represent a change in direction. PBIR will become the default code format for Power BI reports. As one of the largest changes to the Power BI report format in years, we want to ensure the upgrade process for millions of reports is as smooth and reliable as possible.

If you're already investing in PBIR for source control, CI/CD, code reviews, or programmatic report editing keep going. You can continue to opt in to PBIR using Power BI Desktop, and everything you build now will carry forward as PBIR becomes the default and, eventually, the only supported format.

PBIR is not replacing PBIX. PBIX remains the primary file format for Power BI developers. The change is internal: PBIX files will now store reports using PBIR instead of PBIR-Legacy, bringing PBIX and PBIP into alignment on report metadata. For PBIX users, this is a silent upgrade.

What's next

June — Re-enable the PBIR default-on rollout in the Power BI service.
July/August — Enable PBIR by default in Power BI Desktop, contingent on a clean service rollout.
General Availability —will follow for PBIR and PBIP, assuming the default-on rollout progresses smoothly through the summer.

New Desktop Bridge (Preview)

The Power BI Desktop Bridge is a new capability that lets agents and external tools connect directly to a running Power BI Desktop session. This unlocks a new wave of scenarios, especially AI-driven experiences. A great example is the Report Skill, which uses the Desktop Bridge to read, update, and verify reports in a continuous edit–verify loop. The result: faster iteration, smarter tooling, and a much more seamless authoring experience.

Other

Power BI in Teams: Power BI tabs are now supported in private and shared channels

Bring your data into the flow of work with Power BI in Microsoft Teams. By adding a Power BI tab, teams can view and interact with reports directly alongside their conversations.

This experience is now available in private and shared channels, unlocking richer collaboration across scoped and cross-team discussions.

Figure: Adding a Power BI report tab to a private channel in Teams.

Third Party Visualizations

Network Graph by Powerviz

The Powerviz Network Graph is a visual representation of objects and the relationships or connections between them. Its primary purpose is to illustrate how different entities are related or interact with one another.

Key Features:

Merge Duplicate Nodes: Combine duplicate nodes across levels for a cleaner graph.
Directional Links: Visualise one-way and two-way connections between nodes.
Multilevel Relationships: Display relationship tags across multiple hierarchy levels.
Expand/Collapse Nodes: Show or hide node details interactively to control graph complexity.
Ranking: Filter and rank nodes by Top N or Bottom N values across levels.
Link Tooltips: View connection details on hover.
Node Shape: Choose from various shapes, icons, or upload your own.
Labels: Display categories, values, and percentages labels.
Data Colors: Access 30+ color palettes, including color-blind-safe options.
Fill Patterns: Highlight nodes with patterns or upload your own.
Conditional Formatting: Highlight outliers based on measures or category rules.
Clusters: Group related nodes to reveal patterns.
Toolbars: Gain advanced control over the graph.

Other features included are Sorting, Lasso / Reverse Lasso, Grid View and more.

Figure: New features. Better interactions. Smarter network analysis. Take your Power BI storytelling to the next level with the enhanced Network Graph by Powerviz.

Figure: From conditional formatting to smart labels — every new feature is designed to make your network analysis more interactive and insightful.

accoMASTERDATA v1.1.16.2

Enhanced Master Data Governance in Power BI with direct writeback to your own database supporting create, update, and delete operations.

The latest accoMASTERDATA release brings powerful enhancements that strengthen governed master data maintenance directly inside Microsoft Power BI, without an additional application layer. This version focuses on richer data entry, improved writeback flexibility, and better user control.

What’s New

Rich Text formatting for string columns
• Group expanded toggle for column groupings
• Single select formatting for Boolean columns
• Prepend and append characters for checkmark columns
• Transaction key support for controlled row creation
• Multiline text input support
• Support for custom composite key generation
• Pagination for dropdown options
• Custom values allowed in dropdown lists

Key Improvements

Writeback compatibility with database triggers
• Option to ignore empty cells during writeback
• Default values can bypass validation rules
• Improved dropdown usability and ordering
• Enhanced audit logging and governance metadata
• Per-column date/time formatting
• Automatic application of dropdown settings
• Improved bulk editing and UI responsiveness

Typical Use Cases

Financial mapping maintenance
• Organizational hierarchy management
• Product and customer attribute governance
• Planning driver maintenance
• Data quality corrections
• Reference data stewardship
• Allocation and classification ownership

The new version is available now from AppSource. Upgrade to benefit from enhanced governance, flexibility, and enterprise-ready writeback capabilities.

Closing

That’s a wrap for June!

We’re continuing to invest in reducing the gap between asking a question and getting a useful, trusted answer—whether that’s through Copilot, agent-driven workflows, or incremental improvements that remove friction from everyday report development.

MSBI Tutor