The most important changes included in the June 2017 Power BI Desktop update
Part seven of a nine-part series of blogs

This update includes lots of nice features, such as line markers and the ability to change font typefaces, as well as many more changes!

  1. Changes for the June 2017 update for Power BI Desktop
  2. Data Bars in the Preview Table and Matrix Visualisations
  3. Chart Line Markers and Line Effects
  4. Making reports accessible to people with disabilities
  5. Changes to maps
  6. Improvements to the Column by Example feature
  7. Horizontal slicers can now contain images (this blog)
  8. Font family support for visuals
  9. Changes for combination charts

For a cumulative list of all of the updates to Power BI Desktop in the last few months, see this blog.

Posted by Andy Brown on 26 June 2017

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.

Horizontal slicers can now contain images

The title says it all really!

Horizontal slicer with images

Choose a flag to determine which country you want to look at.

However, many people might not have known that slicers can contain images at all!  Here's how to get the slicer above.

Getting the image URLs

The first thing to do is to find a website which contains the images you want to use (I used this one for this blog).  You can then create your table of data:

Table of images

Either import this data from a text file, or just type it in to a new table.

Now click on the column containing the images, and tell Power BI Desktop that these should be treated as pictures:

Image URL property

On the Modeling tab of the ribbon set the column to contain image URLs.

Creating the slicer

Now you have the table, you can set this to be the source of your slicer:

Slicer properties

Base the slicer on your Flag column.

 

You've been able to have vertical slicers containing images for some time, but you can now have horizontal ones too:

Slicer orientation

Change the orientation of the slicer.

 

Add a title and format it a bit, and you've got the slicer at the top of this page! 

This blog has 0 threads Add post