Recently Power BI has released November 2020 update, in this update one of the coolest feature is that now you can add a zoom sliders to cartesian charts (chart which includes horizontal and vertical axes) such as Stacked bar chart, line chart, Clustered Column Chart, Area chart, Stacked and line column chart and so on..
Enabling a zoom sliders feature on chart allows you to easily examine a smaller range of the data in a chart without having to use a filter.
Zoom sliders can be enabled for bar/column, line, line and bar/column combo, and scatter charts.
To take an advantage of this feature you must have installed at least Power BI Desktop November 2020.
Lets take a look at following sample report page, here we have taken a Line and stacked column chart which display the Sale Price and Profit by Year & Month as shown below.
Lets enable the Zoom Slider for this visual, Go to Format pane, and enable the Zoom Slider.. as shown below.
Once you enable the Zoom slider, you will see a zoom slider is added on chart’s Y axis and secondary axis.
Now you can simply click and drag endpoints on sliders to adjust the dimensions of the chart view window as shown below.
You can also enable a Slider labels option, which indicates a new row of labels next to the slider indicating the full range of the data.
Lets enable the slider labels, Go to Format pane, under the zoom sliders.. there you will see a slider labels option, just enable that.
Now you can see, the slider labels is enabled as shown below.
You can also enable the slider tooltips option that makes tooltips appear as you click and drag each endpoint, and display the the value of your selection as you work with the slider.
Lets enable the slider tooltips, under the zoom sliders you will see there a slider tooltips option, just enable that as shown below.
Lets take a look on report, and you can see a tooltip appear when you click and drag each endpoint.
414 total views, 6 views today