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.