COVID-19: Choose between our familiar (but now socially distanced) classroom training courses and our excellent new live online courses.
A summary of the main changes introduced in the December 2019 Power BI update
Part four of a six-part series of blogs

The December 2019 update allows you to customise your visuals pane and format KPIs better, but that's almost it!

  1. Power BI Updates for December 2019
  2. Customising the Visualisations Pane
  3. Many More KPI Formatting Options
  4. Conditional Formatting for Table/Matrix Values as URLs (this blog)
  5. New DAX Quarter Function
  6. The Power BI Features Waiting in Preview

For a cumulative list of all of the updates to Power BI Desktop in the last few years see this blog, or have a look at the Power BI courses that we run.

Posted by Andy Brown on 23 December 2019

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.

Conditional Formatting for Table/Matrix Values as URLs

This is one of those new features which I assumed already existed!  You can now get a matrix or table value to work as a hyperlink:

Web link in table

Click on an animal and you'll be taken to the relevant web page (which in this case will actually just show an image).

To get this to work, go to the visual's conditional formatting and turn web URLs on:

The Web URL property

Turn on the Web URL property - a pop-up dialog box will appear, as shown below.

 

You can then say which field or measure holds the URL you want to display:

Choosing the field

Here I've created an additional column giving the URL for each family.

 

A small step forward, I guess! 

This blog has 0 threads Add post