Two days in the past Microsoft added some new thrilling options to Energy BI with the brand new Energy BI Weekly Service Replace. The extra thrilling one is Drill motion in Energy BI studies. So any further we’re ready so as to add quite a few fields we’d prefer to have on the studies with a drill path. Meaning the customers can navigate from a stage to a different. On this brief article I present you how you can implement a drill motion in Energy BI. Within the “Knowledge Visualisation with Energy BI Desktop” I defined how you can implement and publish a whole visualisation in Energy BI Desktop. On this put up I’m going to make use of the pattern we printed to the Energy BI web site as a pattern. So if you’re not aware of how you can create knowledge visualisations in Energy BI Desktop I encourage you to take a look at this.
-
Login to your Energy BI account
-
Open a report that you simply need to add a drill motion to (as a pattern I’m utilizing Journey Works Reseller Gross sales which I printed beforehand)
-
Click on “Edit Report”
Choose “Gross sales by Product Class” chart -
From “Fields” pane develop “Merchandise”
-
Drag and drop Product to Axis proper behind the Product Class
Now you may see the Drill Down Stage icon (
) on the chart
Click on on the “Drill Down Stage” icon
Voila! -
However, wait! There’s extra. As you seen one other icon (
) additionally added to the highest proper of the chart which merely named “Drill Down”. What’s does is that it places the chart on “Drill Mode”. Meaning once you flip it on the icon adjustments to (
) and now you’re capable of click on on any knowledge factors to drill right down to the associated knowledge within the decrease stage. So once you flip the “Drill Mode” on and also you click on on “Bikes” the chart will drill right down to Merchandise stage beneath the Product Class.
Click on on Bikes
Including Drill Motion to Gross sales and Prices by Area – Map:
All of the ideas are like what we did for the earlier chart. So simply choose the map then drag and drop nation on Location, however, this time above the Postal Code.
As we outlined a better stage the map is already drilled down a stage to Postal Code, in order you may see the “Drill Down Stage” icon modified to “Drill Up” (
).
Click on on the drill up icon to navigate to the upper stage.
Now put the chart on drill down mode then click on on a knowledge level, for example Australia to navigate to the decrease stage of knowledge associated to Australia.
It’s simply lovely isn’t it?
Now we are able to create extra exiting knowledge visualisation with drill actions.
