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 reviews. So any more we’re ready so as to add numerous fields we’d wish to have on the reviews with a drill path. Meaning the customers can navigate from a degree to a different. On this brief article I present you how you can implement a drill motion in Energy BI. Within the “Information Visualisation with Energy BI Desktop” I defined how you can implement and publish an entire visualisation in Energy BI Desktop. On this publish I’m going to make use of the pattern we revealed 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 just wish to add a drill motion to (as a pattern I’m utilizing Journey Works Reseller Gross sales which I revealed 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’ll be able to see the Drill Down Degree icon (
) on the chart
Click on on the “Drill Down Degree” 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 if you flip it on the icon modifications to (
) and now you’re capable of click on on any knowledge factors to drill right down to the associated knowledge within the decrease degree. So if you flip the “Drill Mode” on and also you click on on “Bikes” the chart will drill right down to Merchandise degree below the Product Class.
Click on on Bikes
Including Drill Motion to Gross sales and Prices by Area – Map:
All of the rules 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 degree the map is already drilled down a degree to Postal Code, in order you’ll be able to see the “Drill Down Degree” icon modified to “Drill Up” (
).
Click on on the drill up icon to navigate to the upper degree.
Now put the chart on drill down mode then click on on an information level, as an example Australia to navigate to the decrease degree of information associated to Australia.
It’s simply stunning isn’t it?
Now we will create extra exiting knowledge visualisation with drill actions.
