BLOGS BY TOPIC▼
BLOGS BY AUTHOR▼
BLOGS BY YEAR▼
This update includes lots of nice features, such as line markers and the ability to change font typefaces, as well as many more changes!
- Changes for the June 2017 update for Power BI Desktop
- Data Bars in the Preview Table and Matrix Visualisations
- Chart Line Markers and Line Effects
- Making reports accessible to people with disabilities
- Changes to maps
- Improvements to the Column by Example feature (this blog)
- Horizontal slicers can now contain images
- Font family support for visuals
- Changes for combination charts
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 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.
Improvements to the Column by Example feature
I wrote about this in my April update, and as promised Microsoft have improved what was already an exciting new feature. To remind you, the feature allows you to create new columns by suggestion:

In Query Editor, you can click on this tool to create a new column by example (Excel has had a similar feature for a while).
You can now double-click in the new column, and choose snippets of expression to display:

You can combine different expressions to build up a new column.
Scrolling down and ticking a day name expression for example creates this:

A potential new column to show the day of any purchase.
What this example also shows is that Microsoft have extended the range of transformations possible for this feature, particularly with regard to dates.
- Changes for the June 2017 update for Power BI Desktop
- Data Bars in the Preview Table and Matrix Visualisations
- Chart Line Markers and Line Effects
- Making reports accessible to people with disabilities
- Changes to maps
- Improvements to the Column by Example feature (this blog)
- Horizontal slicers can now contain images
- Font family support for visuals
- Changes for combination charts