WiseOwl Training - Established 1992 Wise Owl Training

Established May 1992
30 years in business
Wise Owl Training
30 years in business
See 519 reviews for our classroom and online training
What is new in the April 2018 Power BI Desktop update
Part three of a six-part series of blogs

This month's update allows users to add customisable buttons to a report, incorporates a numeric slicer and includes a few other smaller changes.

  1. New features in the April 2018 update of Power BI Desktop
  2. Action buttons
  3. Numeric slicers (this blog)
  4. Changing the line and marker style for combination charts
  5. Choose your organisational custom visuals
  6. Features still in preview as of April 2018

For a cumulative list of all of the updates to Power BI Desktop since November 2016 see this blog, or have a look at the Power BI courses that we run.

Posted by Andy Brown on 07 April 2018

You need a minimum screen resolution of about 700 pixels width to see our blogs. This is because they contain diagrams and tables which would not be viewable easily on a mobile phone or small laptop. Please use a larger tablet, notebook or desktop computer, or change your screen resolution settings.

Numeric slicers

These have been loitering in preview for some time, but have now emerged from limbo.  Here's what one looks like by default:

Numeric slicer

Here I've created a slicer based on a quantity of goods sold column (which holds integers between 1 and 8). The boundaries for the slicer have automatically defaulted to the smallest and largest values possible.


You can click and drag on the ends of the slider to change the numeric values:

Dragging a numeric slider

Here I've clicked and dragged the circles to change the values to run from 2 to 6 (I've also reformatted the slicer a bit ...).


You can configure two main parts of a numeric slicer: the Numeric inputs and the Slider.

Formatting the numeric inputs

Here's an example of how you could change the look of the lower and upper bounds for a slicer:

Numeric slicer inputs

Here I've changed the font colour and fill colour for the numeric inputs to an unpleasant red-on-orange effect.


Here are the settings I've used:

Numeric input settings

The settings I used to produce this unpleasant combination of colours.


Formatting the slider

The slider only has one property that you can change:

Slider colour

You can change the colour of a slider - and that's it! I would expect to see more properties added in the coming months.


Here's what the above property would show:

Red slider

The slider is now red (unsurprisingly).


This all seems a bit basic to me, but now that the concept has been incorporated into Power BI Desktop maybe it will be jazzed up in future versions?

This blog has 0 threads Add post