Power BI Update - June 2025

Power BI Update - June 2025

Microsoft Power BI

0:00 (upbeat music)- Hello, Power BI Community.

0:04 I'm Patrick LeBlanc, Principal Program Manager, Microsoft Fabric,

0:08 and welcome to the June 2025 Power BI Monthly Update.

0:13 This month's update includes GA announcements,

0:16 some new public preview features, and a call to action.

0:19 Let's dive in and see what's new in June.

0:22 Let's start with the GA announcements.

0:24 Sparklines are now generally available,

0:27 but the best part of this announcement is that they

0:30 can be used with calculation groups for greater control.

0:34 The calculation group can either be applied

0:36 per data point or across the entire sparkline.

0:39 We have a demo from J explaining all of this in detail.

0:42 Let's jump in.

0:47 JEROEN: In this demo, we'll explore how Power BI's sparkline

0:50 settings affect how calculation groups are applied.

0:53 By the default, calculation groups apply

0:55 to the individual values on the sparkline,

0:58 but we can configure them to evaluate all points collectively.

1:01 Let's walk through an example.

1:04 First, I've created a field parameter

1:06 that sets a threshold value called BigSalesSize.

1:10 It is currently set to one million.

1:13 Then I've created a measure that compares

1:16 the sum of gross sales against the BigSalesSize,

1:20 and if it's high or equal, it returns true, otherwise false.

1:25 Also, I've added a calculation group that contains three items.

1:30 First one is just returning selected measure.

1:33 The second returns the value of selected measure for if big sales is true.

1:43 So only if the sales is above the threshold,

1:45 it will return a selected measure value, otherwise it will return blank.

1:49 And then the third one, which we'll see a little later,

1:53 is a calculation that performs a percentage of grand total,

1:58 which divides the selected measure by the all selected of the selected measure.

2:03 So effectively calculates a grand total.

2:06 Great, let's go back to the report.

2:09 I have created a matrix that shows the sum of gross sales by product,

2:13 and I've also added a sparkline that shows

2:15 the sum of gross sales by month number.

2:17 So there's 12 dots on each sparkline, one for each month number.

2:21 And then we go down the matrix for each product and we show the same.

2:25 We show the trend of the sum of gross sales.

2:29 The calculation group currently is set to actual,

2:31 which means they're just the actuals that are being shown.

2:34 And since the sparkline by default is set

2:36 to apply the calculation group to individual values,

2:39 each month's sales is assessed separately.

2:43 Now let's change the calculation group using

2:45 a slicer to actual for big sales only.

2:49 And when I do that, the sparkline will only show for month

2:53 product combinations where the gross sales exceeds that one million threshold.

2:59 To explain what's happening here, I've added a matrix here at the bottom

3:02 that shows the same information as the sparkline,

3:05 but this time with values and a conditional formatting rule.

3:08 It shows product and month number and the sum of growth sales.

3:11 And as you can see, there's only a few

3:13 combinations that exceed that one million threshold here.

3:19 So since that only happens a couple times,

3:23 the points on the sparkline only show for those instances and not

3:27 for the others since the calculation group evaluates to blank for those.

3:31 So in this setup, the calculation group evaluates

3:35 each individual point and compares it against the threshold.

3:38 And if it's above the threshold above of one million,

3:41 it returns the value, otherwise it return blank.

3:45 So that's why the sparkline is very sparse.

3:48 Now let's change the sparkline configuration to applying to the whole sparkline.

3:58 So the entire sparkline, so this is a new setting,

4:01 you can now switch it to entire sparkline.

4:03 When I do this, you'll see that all the sparklines are back,

4:08 but what happens here?

4:10 Well now the calculation considers the total gross sales across all month,

4:15 and that compares that value, that total value of the sum of gross

4:19 sales for all months against the cutoff value.

4:22 And of course, as you can see here, all of those are above one million.

4:28 However, if I increase the BigSalesSize to 3 million,

4:32 we'll see that the value and the sparkline

4:35 for the ones that were below three million disappear.

4:39 And as you can see here on the right,

4:41 the matrix here on the right that I created using

4:43 the same kind of conditional formatting rule shows that as well, right?

4:47 The Carretera and and Montana product are

4:50 now not highlighted because they're below the threshold.

4:53 So what happens here is that the calculation group now treats all

4:57 the values of the sum of gross sales by month number for each product,

5:01 the sum of those sales as the value to compare against the BigSalesSize.

5:09 Now applying an arithmetic operation like percentage

5:13 of grand total to a sparkline that is set to where the calculation group applies

5:19 to the whole sparkline is not supported.

5:21 So if I switch my aggregate to the percent of grand total,

5:24 remember that did a divide, which is an arithmetic operation.

5:28 If I do this, the matrix will error out and will tell me you cannot do this.

5:33 You need to convert the calculation group to individual values.

5:36 So then we actually can apply that mathematical operation.

5:40 You can simply fix this by either converting it to individual values yourself,

5:44 using the dialog we've just shown over here,

5:46 or just press the Convert button and it will convert the sparkline for you.

5:50 So in this demo, we've seen how calculation groups

5:53 can be applied at the individual or the whole

5:56 sparkline level and how whole sparkline enables aggregations

6:00 across all the data points in the sparkline,

6:02 as well as that some calculations like mathematical operations,

6:06 like a divide or what have you, do not work with whole sparkline.

6:10 You can only apply those to when the sparkline is set to individual values,

6:13 which is the default setting.

6:15 And so try experimenting with different calculations in your Power

6:18 BI reports and see how the sparklines behave.

6:24 Thanks for the great demo, J!.

6:25 Now, let's talk about what's completely new in June.

6:29 All the public preview features.

6:31 Remember, these are just the highlight of some of the great new features.

6:36 For a full list of all the announcements,

6:38 make sure you check out the updates vlog.

6:40 You can find a link in the video description below.

6:44 The first announcement is big news.

6:46 Big news, I tell you, for Power BI fans.

6:49 Everyone has been waiting for this.

6:51 You can finally add tables to import models using Power Query in the web.

6:56 What does this mean?

6:57 Well, we've got a great demo from Emily where she provides all the details.

7:02 Let's check it out.

7:07 EMILY: We are so excited to announce that one of the most

7:10 requested features for semantic model editing on the web is finally here.

7:14 Power Query editing for import models is launching this month.

7:18 Since we introduced data model editing in the service,

7:21 many of you have told us that Power Query was

7:24 the final missing piece for a truly end-to-end in-browser authoring experience.

7:29 Well the wait is finally over, starting this month,

7:32 you'll be able to connect to data, transform it, and refresh your import models

7:36 all directly in the web, no desktop needed.

7:40 Let's take a look at what this looks like.

7:42 I'll start by selecting the Transform Data

7:45 button to open the Power Query Editor.

7:48 From here, I can bring in new data

7:50 using my favorite connectors in the Get Data dialog,

7:53 or I can apply risk transformations right within the browser.

7:57 In my example, I'm working with an employee table,

8:00 and here I see separate columns for first and last names.

8:04 But for reporting, I want them combined.

8:07 I can easily create a custom column using this dialog, no code required.

8:12 After saving this change,

8:13 I can see what my new column looks like here within the data preview.

8:18 Next, I want to clean up some values.

8:21 In the title column, I notice an outdated role name, tool designer.

8:25 Our company now uses Junior Tool Designer, so I'll use the Replace Values option

8:30 to update all of these references accordingly.

8:33 This was another easy transformation I was able

8:36 to make in just a few simple clicks.

8:39 To get a broader view of my transformations,

8:41 I switched to the diagram view in the modern Power Query online experience.

8:45 This gives me a visual map of all applied steps

8:48 and suggestions for additional changes I might want to make.

8:52 Once I'm happy with my data prep, I simply save and apply,

8:55 and just like that, my changes are committed

8:58 back to the model all within the web.

9:01 All of these rich Power Query transformations

9:03 to my import model were done entirely

9:05 in the web without any need to switch between tools or even launch desktop.

9:11 We'd love to hear your feedback on this experience.

9:14 Let us know what you think about this Power Query editing capability and editing

9:18 your semantic models in the web overall

9:21 by sharing your thoughts in our feedback form.

9:24 You can also check out our documentation for more details,

9:27 including current limitations.

9:30 Amazing demo, Emily.

9:33 Next up, Power BI gets a boost with some great new

9:36 features for visual calculations with the introduction of parameter pickers Now,

9:42 it's easier and faster to work with visual calc templates,

9:46 and your reports will hold up better even if you make a mistake.

9:50 Want to learn more?

9:51 J has a demo that explains how.

9:54 Let's take a look.

9:59 JEROEN: We've got a couple of cool

10:01 new features for visual calculations this month.

10:03 First up, parameter pickers.

10:06 Creating visual calculations now got even easier.

10:09 New this month are parameter pickers,

10:11 a fast and intuitive way to select required values with just a couple of clicks.

10:16 Here, I'm picking the moving average template,

10:18 and the parameter picker shows up.

10:21 There's no more guessing or manual typing.

10:23 When you use a function exclusive to visual calculation,

10:25 the parameter picker automatically shows up

10:28 for all required parameters with predefined options.

10:31 And then it is just a matter of point and click.

10:35 And the colored highlights keep everything

10:37 visually aligned between the formula bar

10:39 and the matrix so you always know what data you're working with.

10:43 And if you prefer manual input, no problem, just start typing,

10:48 and as soon as you enter a valid value, the parameter picker will show up again

10:52 so it's easy to continue making further changes.

10:56 Keep in mind that parameter pickers are available only

10:59 for required parameters and exclusive

11:01 visual calculation functions with predefined options.

11:04 Parameters with open text or numerical inputs such as the window

11:07 size parameter on the moving average function here won't get any pickers,

11:12 but of course you can just use typing to enter it.

11:20 Parameter pickers are fast, simple, and efficient.

11:23 So try them out today.

11:25 The next update has to do with access references.

11:29 Ever change your visual type and suddenly

11:31 encounter errors when using visual calculations?

11:34 That's a thing of the past because starting with this release,

11:38 visual calculations won't break due to missing access references.

11:42 So to show you that, previously, if you use an access reference like columns

11:47 here that is not available on a bar chart.

11:54 If you commit this calc previously, this would break the visualization.

11:59 But now invalid access reference are simply ignored,

12:02 allowing your calculation to continue to work and your visual won't break.

12:05 For instance, if you did this, the result simply equals

12:10 the value of the total product cost, and that's it.

12:13 So the access is actually just ignored.

12:19 And then the final update for visual

12:21 calculation this month is the integration into Explore.

12:28 So Explore already makes it easy to dive into your data,

12:31 but now it's even more powerful thanks to visual calculations.

12:36 You can now create visual calculations directly in Explorer,

12:39 whether from the matrix or from the visual here

12:42 at the bottom and just click New Visual Calculation to get started.

12:47 And the same familiar interface as before that you

12:50 might be familiar with in reports shows up,

12:52 which is called the visual calculations edit mode, complete with highlights,

12:55 templates, and parameter pickers that I've just shown you.

13:02 And once you're ready to add this calculation onto the matrix or to the visual,

13:09 you go back into the Explorer and then

13:11 the auto visual will also show that same calculation.

13:23 In case the auto visual cannot display the data, it will enter an error state.

13:26 But no worries, you can simply adjust the visual

13:29 type or remove the calculation to get back on track.

13:32 So by combining Explore with visual calculations, your data analysis is faster,

13:36 more intuitive, and more powerful than ever before.

13:41 Thanks, J, for such an amazing demo.

13:43 Are you using Power BI Mobile?

13:45 Are you using org apps?

13:47 Good news.

13:48 Org apps just landed in preview on Power BI Mobile app.

13:53 Now you can find them right alongside your workspace apps.

13:56 And the navigation is super simple, designed just for mobile users,

14:01 even cooler, you can use features like NFC tags for instant access.

14:06 Curious how to give it a try?

14:08 Let's check out this amazing demo from Maya.

14:14 MAYA: Org apps are now available in the Power BI Mobile app.

14:18 Let's take a look at a workspace.

14:20 You can now view all of the org apps in a workspace.

14:23 You can use the new apps filter to filter a workspace by apps.

14:29 You can also view org apps alongside workspace apps in the app section.

14:35 Now let's open the org app.

14:37 When creating this app in the Power BI service,

14:39 I added an overview page, which acts asthe landing page in this app.

14:45 This page, as well as the entire app,

14:47 support the same theme defined in the service.

14:50 The overview page displays the app title,

14:53 description, and content, and is fit for mobile.

14:57 Sections are of course supported as well, just like in workspace apps.

15:01 You can expand and collapse them as needed.

15:06 The overview page allows you to navigate to any item in the app.

15:10 To move to another item in the app or return to the overview page,

15:14 you can use the app navigation tree,

15:16 which is the mobile version of the app navigation pane,

15:19 and includes all of the supported app content.

15:22 Or simply press Back.

15:24 Fabric artifacts that are not supported in mobile,

15:27 such as notebooks and real-time dashboards, will appear in the org app content.

15:31 You can tap the item to view info about it and use

15:35 the View on Web button to open it in the browser.

15:38 The org app also appears on the homepage under recents and frequents,

15:42 and are searchable like any other Power BI item.

15:48 Thanks for the great demo, Maya.

15:49 Last up, we have a call to action.

15:52 The Azure Maps visual in Power BI has some big updates,

15:56 and there's something you need to do.

15:59 Admins now get more control over where location data is stored,

16:03 especially for US and EU customers whose data now stays within those regions.

16:08 With the June release,

16:10 admins should review and/or update the new Azure Map tenant settings.

16:13 Log in and check out your settings today.

16:17 That concludes the updates for June.

16:19 We encourage you to visit our Power BI Community Forums at aka.ms/pbicommunity

16:23 where you can connect with peers and find answers to all your questions.

16:29 Remember, your feedback truly matters to us.

16:33 We're always listening.

16:35 If there are specific demos or topics you'd like

16:37 us to cover in the future, please let us know.

16:40 And as always, if you have any questions, comments,

16:43 you know what to do, post them in the comments below.

16:46 If you like this video, be sure to give it a big thumbs up.

16:49 And if it's your first time here, be sure to hit that Subscribe button to stay

16:53 up to date on all Power BI features and updates.

16:56 Remember, thanks for watching.

16:58 We'll see you next month.

Study with Looplines Download Captions Watch on YouTube