WiseOwl Training - Established 1992
COVID-19: Choose between our familiar (but now socially distanced) classroom training courses and our excellent new live online courses.
This page has 0 threads   |  Add post
Five star reviews Outstanding course feedback
Average score 9.33 out of 10, based on 8996 reviews
If you found this blog useful and you’d like to say thanks you can click here to make a contribution. Thanks for looking at our blogs!

BLOGS BY TOPIC

BLOGS BY AUTHOR

BLOGS BY YEAR

A summary of the new features introduced in the September 2018 Power BI update
Part three of an eight-part series of blogs

The September update of Power BI finally breathes life into report page tooltips, which have been in limbo for a while. You can also copy data from Power BI reports by right-clicking, use some keyboard short-cuts for visual design, apply built-in themes, set fixed-width padding by column example and show categories on the X axis of scatter charts.

  1. Changes introduced in the September 2018 Power BI update
  2. Report page tooltips
  3. Copying values and records (this blog)
  4. Keyboard short-cuts in Power BI Desktop
  5. Built-in themes
  6. Column From Examples now allows for text padding
  7. Improvements to dot (scatter) charts
  8. Features awaiting in preview as of September 2018

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

Posted by Andy Brown on 21 September 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.

Copying values and records

This is a simple change, but a very useful one!  You can now copy data from a visual, either by value:

Copying value

This would copy the single value 89422.50000000028 (with an unnecessary and inaccurate degree of precision).

Or by selection:

Copying by selection

For this example you'd get a table consisting of the column headers (not shown in the screen shot) and the East Anglia row of data.

Here's another example, this time with a column selected:

Copying a column

Here we have a column of a matrix selected.

This is what the above would give if copied into Excel:

Data copied to Excel

Data is copied with its formatting.

 

Microsoft are planning to enhance this feature in future releases of Power BI, but even now it provides a great way to check figures in Excel.

  1. Changes introduced in the September 2018 Power BI update
  2. Report page tooltips
  3. Copying values and records (this blog)
  4. Keyboard short-cuts in Power BI Desktop
  5. Built-in themes
  6. Column From Examples now allows for text padding
  7. Improvements to dot (scatter) charts
  8. Features awaiting in preview as of September 2018
This blog has 0 threads Add post