 Good morning. Good afternoon and good evening everybody and welcome to another D Brown consulting webinar series This is our webinar series on Excel and Power BI. We do this every third Thursday of the month from 9 a.m.. To like 9 45 a.m.. And Today we're going to be talking about top 10 Power BI updates in 2019 Quite a lot of updates in 2019 We're just trying to it's kind of difficult for us to go through and pick 10 So that's what we're going to talk about today top 10 power bear update in 2019 so let's get started. Let's jump right into it and Just a quick intro to me. I am David Brown. I'm the managing partner of D Brown consulting I'm also an international consultant to the World Bank and a Microsoft MVP on data analytics So on the data platform. So this is this is me You can see my handle. You can follow me on Twitter D Brown analyst and you have all my videos on YouTube You can see that link there So join me and let's just jump straight into it those updates for 2019 Well, you can also join our power bear user group because we have quite a lot of Resources online if you go to meetup.com go to meetup.com you can look at look us up as Nigeria modern Excel and power BI User group that's on meetup.com right. We also have the financial modeling meetup group So if you just go to meetup.com, you can also just look for financial modeling so here we're more than 4,000 members now and it's growing and we do meetups we also have we also Managing the Nigeria modern excel and power BI user group on the power BI I'll go the power BI user groups on PBI user group.com slash Lagos So if you go www.pbiusergroup.com Slash Lagos and that's where you get us. So that is the Niger modern excel and power be a user group great Just a quick word about our sponsors So we have D Brown consulting sponsoring this webinar and of course, this is a power be a user group Power be a user group webinar. And as I said, it's every third Third Thursday of the month and we also actually have a live meetup every third Saturday of the month Yes, a live meetup different venues and stuff probably show you the link at the end of the webinar You can actually type in the chat and then we show you the link as well. We'll just share that link with you Great. So jumping straight in Top 10 power BI update in 2019 As I said, it was quite challenging to decide which top 10 was going to be the top 10 So we decided we're going to go every single month of updates so in January typically they don't do any updates in January and They start the update process in February. So February, let's jump straight in there. So this was February 2019 so this is what the updates that they had in February 2019 So reporting the updates to the new filter pane So the filter pane there was some really interesting updates more filter pane formatting and stuff like that Very good updates to the filter pane cross highlighting in single points in Linechats cross highlighting to us. We think that was kind of the best we saw in February So I'm going to quickly highlight that there was also water up on titles Update default visual interaction to cross filter rounded corners for visual borders. That was very nice I always like rounded corners Analytics the key influential visual was actually released that could have been the best But I'm going to leave that and just give you a sneak peek actually key influencer visual is just something else It's an AI visual inside questions with Q&A another AI visual Auto-generated suggestion questions in Q&A Explorer too many wonderful things in In February, I think they just left all sorts of stuff to put in in February That was to start the year off with the bank kind of stuff. So custom visuals There were some custom visuals released custom visuals quite a lot of custom visuals and then you had the data connectors Every single month there are lots of data connectors So solving monkeys one big one that was added in February 2019 So quite a lot of updates in in in February. So what did we pick? So in the February we picked cross highlighting in a single point in a line chat What do we mean by that cross highlighting a single point in a line chat? so that's what we picked for February and Here it is. So if you have a line chat, just key key create a typical line chat Yeah, just create a typical line chat and what that means is if you look at this dot We can now click on that dot and it cross highlights everything. So for this particular dot in March Where the revenue was about 8.4 billion and you can cross highlight just that dot and it's like clicking March So you don't need to have a visual you don't need to have January to December as a Slicer you could actually go into the chat and kind of slice by point point by point and it's gonna slice by month Of course, if you click it again, it just goes off you click it once it goes on click it again and then of course you could have your Different visuals that you put on the slicer. So you have your tooltips So those tooltips if I come to this visualization here if I click on this visual Then I click on here. You'd see tooltips tooltips is on And tooltips you're able to show that tip of a revenue sum, right? so you could click here and Just click up here and you have the visuals you can drop more things into this tooltip Section and then you could have more Context for various tools right various visuals very cool very cool stuff. So that was February. That's our pick for February What about March? So in March March 2019 another set of updates. Where does the single select slicer single select slicer? You had heat map supports for big maps you have cross highlighting Small filter pane improvements and then analytics Q&A recommendations for improving results Show dates as a hierarchy now generally available They kind of released that the year before but it was in beta form So quite a lot of updates right PDP in PDF connector now supporting tables spanning multiple pages This is this was big. This was really big, but we had to pick one right so PDF connector I mean you could you could use PDFs data and PDFs and he could use Power BI to connect to those data It's really wonderful stuff in March. So what did we pick for March? What did we pick? We picked single select slicer Right single select slicer Yes, and what does that mean? What does single select slicer mean? So typically when you have a slicer here look at this you can click on north Northwest right and you see everything kind of filtered to northwest and here you could do multi selects You could click a hold your control key And click to do multi select so this is like a multi select thing But sometimes you don't want your users to have that option at all. You just want them to do single select So what you do if I click on this visual, which is a simple typical Slice of visual I'll come in here come into this Come into the formatting then under selection controls. They added this button here called single select So this single select here if you click on this single select You'll see that we can now just click one at a time just a single select Right. So if I remove that single select, then you could do your multi select And in the multi select actually here you have multi select with control, you know, I held the control key You can actually switch that off. So they can't do multi select with control is the tick So you just tick tick tick or multi select, which kind of is better instead of control, right? So you could use control or not control show select all option So if I click on that select all option you have that select all option I click select all right Or not. So just a bit like excel, isn't it? So I kind of like the single select So a single select this just makes kind of forces you to only select one at a time So it depends on how you want to do your reports. It just gives us various options for our slicer So this slicer you could decide a single select multi select multi select to control multi select with no control All sorts of stuff really good stuff. So that was our pick for march Let's see. What did april have to offer? So april A lot a lot of stuff on april this analytics you have drilled through a cross reports This was really good But he had key influencer visual now supporting continuous analysis for numeric targets key influencer again It's a huge visual is another a i visual quite a lot of stuff here Filter pain was a big one filter pain improvements So lots and lots of improvements on filter pain. We just have to give it to filter pain filter pain was just superb filter terrain improvements if I go to the april Get the april. Let's see. I'm going to pick Okay, let's see. What was this this a renegade some renegade visual here. So let me just delete that Okay, so if I come into april supporting the filters, so you have filter pain What was that they they actually improved the filter come to view here You can't see the filter pain here have to go to view and then I can click on this filter pain so Quite a lot of improvements to the filter pain and in that month Let's let's recap. So what were the improvements? They had filter pain improvements included support for full filter pain editing You had ability to rename filters filter pain scales with the report page Restrict a bit restrict ability to change filter types improve filter pain accessibility So those were all the improvements So if you look at the filter pain here, you could drag this is filter on this page filter on all pages You could drag stuff there. So I could say okay come I want to filter Right now I have my regions here. This is my regions. I could decide, you know what? Let's bring regions in if I take my store D store I'm going to pick regions and drop it in here. So filter this page by region Click there So filter this page by region if I pick north central, you'll see that it filters the report So it's just north central here. I can so I can decide, you know, what I'm going to pick this north central And I'm going to lock it. You can see that I'm going to lock it here. So I'm locking it And that way if I click this and I hide my filters So I've kind of locked it in and that's just north central. Nothing anyone can do about it, right? So if I if I come back, how do I get my filter back? You come into view And you pick the filter Then you come here And I can unlock it. But if I click on this Let's say north and north central and lock or I can just unlock it to allow people to edit, right? Basic filters advanced filters and the other thing I can see filter on all pages I can decide, you know, I'm going to take this And I'm going to drop it here. Let me just kind of Bring it take it out and let's come and take maybe let's say model Let's take model name and put it here So what this means is that this filter is on all pages So that means every single page here is going to be affected by this Almost like a universal filter, right? So if I click on ad hoc services So if I go to another sheet maybe or another page or like call it sheet or like excel So another page. Let's say February ad hoc services So it's technically filtered by ad hoc services, right? That's what it means is ad hoc services Yeah, look at that So this ad hoc services affects every single page. So once you click it, it just affects every page And that's that's filtered. So quite a lot of updates for filter This filter pane in editing and improvements were really good in april. So that's what wins our Our best update for april Great. So what about may so what happened in may so what do you guys think of the update so far? Which do you prefer type it in the chat type it in the chat? Let me recap So we had In february the february update was cross highlighting on a single point Single point cross highlighting, right? That means I can go to my chart and pick a single point and it will kind of cross highlight the entire Report right cross highlight the entire report really cool. So that was february March we saw that we picked single select slicer, right single select slicer Being that you could come here and change your slicer from what it was multi-select before you come in here You click on selection control And then you switch on single select. Yeah, this was single select that they added in there, right? Previously it was multi-select and I can say multi-selected control I hold my control key. So it depends on your users what your users want, right? So which do you prefer of the two? So I've just shown you this too which you have The Point on your line chart that you can select Or the single point on your slicer that you can select Or in april the big improvements to the filter pane out of these three type in the chart, which you think Works best or which which you think was the best I wouldn't I wouldn't be biased, but um I think the filter the improvements of filter are really really cool. All right. So that april that's like Technically first quarter all this one month after first quarter the first three months So let's see what happened in me. What happened in me? So in May, these are the things that happened. We had performance analyzer pain now. This is big performance analyzer Even though we didn't pick it. I think it's worth a mention Performance analyzer pain was huge. This is it here if I go to view now if I click this drop down here This is how I used to look before you also. These are improvements to the UI So if I click on the performance analyzer, I know it wasn't chosen It's not part of our analysis, but you could click on start recording and then analyze how what the what's the performance or power bi What's the performance? How well Is is it doing what it should be doing right? How well is it running this visual? So you see all this analysis on how quickly these visuals ran, right? You click on text box You see, okay, this visual how it ran it ran pretty well Let's see text box doesn't have any any DAX if I click on this one, right? If I click on this, let's see how this Analyze let's check a line chart. So if I click on this line chart, you can see it has some DAX The DAX took 29 milliseconds. Very tiny. If I click on the copy query I'll be able to copy whatever the DAX query is and go paste it somewhere and check it out This is cool. This is big performance analyzer Well, we didn't pick it. We had to vote right? So we didn't really pick it performance analyzer But please check it out. So what did we pick? What did we pick? So that was our me, right? What did we pick for the me updates? Let me close performance analyzer minimize this minimize this So these are all the updates. I love performance analyzer. It's extremely good when you're deploying a power bi We're doing a deployment a power bi deployment Yeah, it's it really shows you what is making things slow How do we improve our DAX? Right, what about the filter pane improvements sorting filter cards theme supports with continuous improvements in filter panes table and matrix keyboard navigation line data label position control kpi visual indicator text size control Analytics key influencer visual improvements. These were really big improvements. Binning support formatting options mobile support Then modeling updates to the all selected DAX function. I think we had to update certain things that probably we're not working too well Visualizations always good new and better and better visualizations And data connections more data connection connectors. So out of here. We chose the key influencer visual So we chose the key influencer visual and that was our main Top visual for that month key influencer visual formatting options So if I go to may Demo, what is the key influencer visual? Well, let's see. What is influencing certain metrics in your data? Key influencer is actually an AI visual. This is it here As you look at it here key influencer if I click on it So this is key influencer visual. Let me just make it big here So this does a lot of regression, right? If you like statistics, you will love this because it goes through all your data and tries to explain things Very important visual. So if I come let's bring in some data. Let's click on this. Let's see And what I want to analyze. Let's say I'm analyzing budget variants, right budget variants So here I just selected a Metric I just selected a metric called budget variants. So see what the key influencer visual did. I just take this says What influences budget variants to increase or decrease, right? What influences budget variants to increase or decrease? So let me choose a decrease So what influences budget variants to decrease great And of course there's no data here. So let's pick some things. Let's pick something. Let's say What influences to increase for Let's put some dates. Let's put large data and say dates where is it dates? I don't want to group these dates. So I'm going to show on date itself just the date Let's say store, let's say region, let's say state Let's say So you see right now it's not analyzing anything because there's not enough data You need a lot of data for it to analyze. I'm going to put store name as well So it's it's gathering all the data and just like statistics you need Critical mass of data for it to really do some analysis that makes sense. So I put region state and store name. Let me add some more data. Let's say Model name, right? Okay. That seems to be enough for now. Good. So you see so I've analyzed I've added I want to know what influences budget variants to decrease Yeah, so budget variants to decrease the budget and actual budget variants to decrease form region state store And model and what did it come up with it says When the average of budget variance decreases by 7.59 when the model name is General repairs. Okay. So When the model name is general repairs The average of budget variance decreases by 7.59. So just model. So this This is general repairs. So general repairs seems to be Where the major increase decreases in in budget variances are coming from. All right. All right. It's interesting So if I click this then you see further analysis here budget variances So it breaks it down into bins. So what the updates they did is Binning things that they kind of increased or improved the way they could bin things Okay If I click on only show values that are influencers. So these are the main influencers general repairs Motherboards printer repairs and this and yeah, so we could go a step further and go to top segments What are the top segments that are really influencers? So you have segment one You have the average of budget variance in the population count So 98.53 percent on the segment one if I click in segment one itself to see what that's all about So you can now see some more analysis about segment one on the overall performance And segment one contains 124 data points 13.9 percent of the entire data In segment one the average budget variance is 98.53 negative This is 6.54 units lower than the overall average variance Okay, so If it's what when a budget variance more likely to be lowered about high when is budget variance more likely to be high All right, let's see that So it's running the analysis going doing doing the same regression again doing it all from scratch again And this doesn't look too interesting. Let's go back to key influencer And I say, okay, what influences budget variance to increase let's say decrease right less influences it to decrease Let's see what influences to decrease quite a lot more things And he sees analyzing there. So we could you could be on this for all all day I mean, there's so much interesting stuff going on there. We don't have that much time. So let's move on So that was our may update right our may update So the may update just recap by click on this. Hopefully it comes up It's coming up. Don't crash on me. Please. This is quite a heavy file. So It's kind of dragging. Okay. So those are your performance analyzer And what we picked was the key influencer visual improvements, right? That was our me. That was our may updates So what about june? What's happened in june? Let's quickly jump into june June june updates. What can what can we say about june? So june Click on Hopefully come up come up come up come up Oh, I'm jumping straight to july. Okay. I guess we didn't we jumped june. Let's keep june. Let's just keep june Not much time. So july what happened here icon sets for table and matrix percentage support for conditional formatting by rules New filter pane is now generally available with filter pane. I showed you the other time. That was the beta analytics count For key influencer visual Improvements, there are lots of improvements. So what did we pick or what was our pick for july? We picked data colors support when using play axis on scatter plot Now there was just I think a small snag when it came to scatter plots But scatter plots are one of our most favorites or favorite visuals really really Super visual because it kind of tells a story What is scatter plot does is you have two variables and trying to say one variable explains another variable, right? So for example revenue and transactions is a classic one You have revenue to the left here and then you have transactions here. So you have transactions you have revenue Right and we're saying as revenue goes up. We are hoping that transaction goes up So if you look at this visual here, this is north east I had to hover over these things to see what they were So this is north east and you have 34 transactions and 65 million error in sales So if I play my axis you could see them Moving pretty nice, right? I pause but the support what changed really I think is the legend So we had a legend. I mean you could switch on the legend and you see the legend come up here which we didn't have Couldn't switch off or on or whatever the legend now can switch it on and off and that's it here up there So that was the improvement for the scatter plot and scatter plot is a really favorite visual of us. So that was really nice so that was the updates for July that's our pick august what happened in august so august We had not too much updates. We had grouping visuals filter painting migration icon style picker for icon conditional formatting conditional formatting Warnings and then key influence. I again had measure support general availability quite a few things here. So What was our pick? pick was grouping visuals So grouping visuals I'll show you another visual to see how we group visuals, right? So grouping visuals. I'll just come to this visual here and If I click this visual and I clip this visual less as even has so many more visuals And I just want to align them and take them work on them at the same time You could click this hold your control and click this and right click Then you see group and you group now. They are one visual and I can kind of drag All of them at the same time. See that I can just click and drag. Yeah I can drag them all together Right, and that's grouping visuals pretty cool Hey, you can always on group as well. Just right click group on group Right. So that was good, especially if you have so many visuals to manage and you need to kind of Align them and do all of them at the same time. So that was grouping visuals. So yeah, that was our pick for august And let's move on to Yeah, so what's the next one september? So quite a few more Um improvements color and text classes in themes New default themes. I think this this was big. And in fact, that was our pick new default themes Although they had a new function a new dax function In september, which is remove filters and convert for the dax lovers. This was really really good You had to you really know more complex dax computation or create a how will I call it create create Lots of functions together to be able to do this effect But this was this kind of improved your dax writing Skills right new filters to kind of help you out remove filters and convert Data preparation copy to clipboard from data profiling also pretty good. You check that out online Direct query support generally available also very good Power app visual now generally available. That's super power apps We're going to be doing quite a lot of power apps in our meetups this year So watch out lots of power apps in our meetups this year and power automate So what did we pick? We picked new default themes new default themes because it's so much easier to use new default themes So that was our pick new default themes. Okay, and on pin visuals. What does that mean on pin visuals? Okay So new default themes you could get that right here in view if you go to view up here See view you click here and these are the new default visuals I can click on one of the themes and it kind of updates your themes you click on themes if I had many colors You would have seen the effects. I don't really have bars with colors. You'd have seen that effect there So these are your new default themes and of course you have your browse Browse for themes if I can go online and browse for themes or I I can pick themes here, but really let's leave that and Yeah, you could do if you do Jason you could you could get exports your theme you could How to create themes I can click on that you'll see how to create themes to just pop up A video online for you to see or it's actually documentation online from microsoft on how you actually Report or manage themes so that documentation. Let me just pop it here for you to have a look So this is it once you click that. This is how Different documentation on using themes if you go to docs.microsoft.com You'll be able to go there or just click it directly and you see Read all about it and see how do you create your own nice wonderful themes to make things easier, right? Very cool. Very very cool. So quite a long documentation, but it's worth reading Because once you create a theme you manage it all your reports will be standard Beautiful and that you'll learn a little bit of Jason because you need that code But there's lots of templates for you to use here So read it. How did I get here? Let me remind you I went to Down here for the view view tab click here The under view tab I clicked on the drop down for themes. Hold on a second System seems to be misbehaving This tool is quite heavy Slow down guys. Slow down. Good. All right There we go. It's still there. Okay. Good. So here how to create themes That's what you click once you click that it's going to open the microsoft documentation and creating themes And that's how you get them. Great. So that was for september themes. Then what about on pinning visuals? What do we mean by that if I go to visualization? Right. These are your standard visuals and many at times people You don't use certain visuals like this pie chart. This pie chart is terrible. Don't use pie charts You can always get a better chart than a pie chart So right click this pie chart and say hey, I'm on pinning this visual. I don't want it anymore So it's going to on pin this is going to remove pie chart from here And it's just going to add it to almost like a custom visual. Look at the warning it says You're about to remove this visual from the visualization pane to use this visual in the future You'll need to restore default visuals. So you click okay And guess what pie chart is going to leave here and it's going to join this guy here. Just watch Hopefully move on move move Yeah, it's taking a while to play this pie chart doesn't want to move Just give it a few seconds Pie chart off you go Um pie chart is pretty stubborn You see you on pin the visual and the guy refuses to go click. Okay. He's supposed to move out Now he moves out guys in there. So now he moves out. Look at the pie chart there So you could right click and right click and on pin all the visuals You really don't want to use or you don't use regularly. So you kind of declutter this place, right? And of course, you still have your custom visuals So your custom visuals you could click here and then pick custom visuals that come down here, right? So that's on pinning visuals really good But if you want to get your pie chart back, you need to click on these three dots here And then say restore default restore default visuals, right? Delay custom visuals import custom visuals import from file all sorts of stuff. Perfect. So that was your september pick from us What about october? What do they have for us in october? What do they have from microsoft for power bi? So another long list of updates On reporting they had automatic page refresh for direct query preview. Really nice This is on a preview. It's not generally available as at then the new q&a visual. This was really big the new q&a visual Improved user experience for q&a a lot of stuff on q&a natural language improvements for q&a q&a tooling Support for sses and azure as including rls this q&a I mean you could just see there's so much stuff on q&a power apps visuals now included by default New xvis visual that's xvis Our friends from xvis, but well, guess what of course we had to pick q&a. I mean q&a was just A huge improvement. So the new q&a visual was was was it right? So what were the improvements quite a lot you could could read about it But how do you use q&a? You just go to your Page and double click you double click the q&a visual will appear And that's it coming up. Yeah q&a so I can make this a bit bigger So we can see this right. So this q&a Right, so it kind of suggests things for you based on your data is giving you suggestions on how you can write your q&a And yeah, so you just you're just right. So let's take one of the suggestions. So let's just do ours, right? What is sales by region right by region For which year is that now you can see it's giving me various states. Let's say 20 I don't know what data this is 2014 you have data for 2014. Yeah, okay. Good. So that's my q&a So what is sales by region 2014? Let me say as a Pi chat. I don't like pie charts, but let's just say pie Chart right No, did I remove pie chart? Can you see that? I've removed pie chart. So it's not there anymore. So no pie charts for me, which is good So as a map Can you do region by map but regions? I'm not too sure we'll do a map Let's see map. Let's say matrix matrix visual is nice Well, it did actually it did by map, but let's go to matrix choose matrix so it's Sleeker better Nice, sir. This is it. So this is this is your visual. Yeah, not bad at all All right, so that's the new q&a visual you could also click on this Cog for settings for the q&a visual and then see lots more things review questions You want to review question people have asked fixed and fixed misunderstandings So when you're reviewing you're trying to see okay, someone asked a question and gave a different answer How do we improve that you want to teach the machine learning algorithm? You want to keep teaching it to understand what you what's best? What are the things that you think are best? Understanding you better as a person or a group of people and the terms that people use you're teaching q&a Right managing managing terms manage the terms and definitions you've taught q&a Right and help so you could click on this and you basically goes online goes to the documentation online And youtube and plays a video to kind of help you out on understanding how to use this thing. So it's Really really good stuff excellent stuff, right? So let me close that Great, so that was your q&a review questions teach q&a lots of stuff lots of stuff And then of course if you like the visual if I close this you can always pin the visual right you like this visual You could always click on this and say turn the q&a result into a standard visual once you click it This becomes a standard visual you'll put it somewhere else and you can come into your blank space and double click again to do a new q&a Right, I just double click and I do my new q&a and we go go on right ask another question And then you'll be able to create your own custom visual. I mean create a beautiful visual with another q&a, right? Let me see I need Sales by model All right Okay, I didn't spell that well sales Sales, okay. I know sales by model. It's not bad. I know sales by model Right, and I like this one as well. So let's go. I know sales by model And let me reduce the size of this So you just play around with your q&a. I like this. I pin it and and you just go ahead and that's it So q&a big improvements for q&a in october. What about november? so november We had modern ribbon preview. So november big thing was the modern ribbon But they were kind of more big things you had the decomposition tree visual as well as a preview then conditional formatting button formatting conditional format button formatting Visualizations new interesting visuals zoom chart drill down waterfall charts and stuff But this this this too, right? We're super big modern ribbon preview. That's what you're looking at right now This is the modern visual a modern ribbon everything here. That is the modern ribbon big big improvements I can minimize the ribbon now and then I can actually go to view And see the filter see I can activate the filter pane I can deactivate the filter pane selection pane performance analyzer under view help had so many more things So I can kind of minimize this so this was a big big improvement I mean the ui is getting better and better Textbox ask a question buttons shapes images everything that you insert So what they're really trying to do right is almost make it look like excel powerpoint and An office right they're making it almost look like office eventually. I can predict this for you under home You're going to see some formatting stuff So if you want to format see click on something you just be able to format it almost like office right now So it's getting better and better the ui. They're doing a lot of work on the ui, right? So that was um Really I did the cut out the back the november pick for us was the modern ribbon for sure The modern ribbon super excellent And that's what you have up here, right the modern ribbon makes it easier. It's more intuitive And it just looks better and more professional the the product is getting mature really nice So what about december our last one? What about december? What was there in december? again quite a lot of Stuff in december customizing current theme export current theme setting table columns or metric value to a custom url kpi's New decomposition tree formatting and stuff but really How we will pick I mean there was a new function to quarter. I haven't even tried I wouldn't use that. I need to check that out loads more analytics inside and lots of stuff lots of interesting stuff so Reporting what did we pick it has to be the decomposition tree? So the decomposition tree Was really something what do we mean by the decomposition tree? So let me do a quick demo So here's the decomposition tree. This is how it looks. It looks like a tree branches out and stuff So why do you pick it is another? Of their ai visuals right any visual you see with this kind of tiny bulb is an ai visual So you lost of ai so if I click on the decomposition tree, this is it here, right? Any one of you has used this in powerpoint powerpoint. There is this transition called morph No, that's some super transition And that's a bit a bit more feel like morph, right? So this is your decomposition tree Let's do some analysis. Let's say we want to decompose. What let's pick a metric. Let's pick a metric let's say lots of metrics lots of metrics revenue or Transactions Distinct count annual sales. Let's just say annual sales, right? So annual sales Uh, oh, what did I pick? This is not decomposition tree. This is key influencer. Let's go. Is this the decomposition tree here decomposition tree Yep, so i'm analyzing annual sales. Yeah, look at it. So this is annual sales. How are we going to break annual sales? Let's break it by categories, right? So you have a metric first and then you want to break it Reported by hierarchy. So let's pick region first. So if I pick region, so this is region I just selected region. So if we click on this plus sign It's going to give us the composition of a region, right? Let's click. Don't click click Click out. Oh, let me slow down Click. Yeah, there we go. So northeast southeast southwest and everything then let me bring in Region, let's say state, right? So pick state. So if I pick state and I pick this click on this So by saying that we have annual sales for northeast And I click on this plus sign. Let's say high value Uh, what's the high value? So this is these are the States under northeast you have your region your state annual sales is highest when state is Gombe. All right, that's good Okay, it's highest when state is Gombe And and then I guess it's lowest when state is Borno, right? Right and then state you can say, okay, do you know we also want um, let me pick Model name Right. So model names of this state in particular. What was the lowest value? So model name, right and these are all the Values for products. Yeah, I'm zooming in and out with my mouse This is me zooming in and out and then I can go put something else there So zoom in and out on of course is all cross highlight and you could cross highlight stuff Have this here and then you use it to kind of cross highlight other things as well You click on this this decomposes that this decomposes that This is really good. I mean, this is super super good. Gombe had the highest and these are all the percentage sales for all the rest Uh, go play with this. It's beautiful. Really beautiful I guess anyone in hr. We think you could create a nogano gram with this. It looks like a nogano gram Right. So that was december, right? So guys we've gone through 10 plus one bonus, right 11 or let's say 10 We left one month out. So it's 10 So it's really 10. Those are our 10 10 best best best visuals So please go online. Go to our online. Go www.officetraininghop.com. You see lots of trainings there We're developing training free trainings for power bi free training for power apps and stuff They're going to be loading onto this website very soon. There's a free excel training there right now So go to www.officetraininghop.com go enjoy that And if you also want to learn a lot about power bi, we have a reporting and analytics of power bi course Go check it out dbrown consulting net and learn power bi with us Right. So this was a webinar from our monthly webinar series This is our top 10 power bi updates in 2019 And i'm david brown and i'm really glad to kind of share this with you Please type in the comment below which was your best visual for the entire thing What was your best? I think I think I love the decomposition visual But uh, but there's so many So many more right. I mean the decomposition tree Then you have excel and power bi webinar series That's us meet us again every third thursday of the month from 9 a.m to 9 45 a.m any questions anyone wants to type in the chat any questions you have just type it out in the chat You want to have the link to register for their webinars the link is there Join the link there and if you want to register for our other webinars We have webinars in financial modeling and we also have live meetups every third saturday of the month We're going to share the link as well there Third Saturdays of the month. All right. So thank you everybody for joining us for another dbrown consulting power bi and excel webinar series This was a webinar on the top 10 power bi update in 2019 great See you again next month same time Hope you enjoy your break and everybody's enjoying their break of course and we'll see you again next month. Thank you guys I'll just hang around a little bit on the chat and just chat with a few of you And thank you. See you next month. Bye. Bye