BLOGS BY TOPIC
BLOGS BY AUTHOR
BLOGS BY YEAR
The December 2019 update allows you to customise your visuals pane and format KPIs better, but that's almost it!
- Power BI Updates for December 2019
- Customising the Visualisations Pane
- Many More KPI Formatting Options
- Conditional Formatting for Table/Matrix Values as URLs (this blog)
- New DAX Quarter Function
- 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:
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:
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:
Here I've created an additional column giving the URL for each family.
A small step forward, I guess!
- Power BI Updates for December 2019
- Customising the Visualisations Pane
- Many More KPI Formatting Options
- Conditional Formatting for Table/Matrix Values as URLs (this blog)
- New DAX Quarter Function
- The Power BI Features Waiting in Preview