Sapiens

A must read.

It will get you thinking about how we have progressed and whether it has been progress or regress. Have the lives of sapiens improved over the thousands of years?

What about the planet and the other animals on the planet, (the ones we haven’t killed off any way) are they better off?

Hacking Power BI

Chris Webb
2017-04-11

Chris Webb’s BI website is a great resource on Power BI, DAX and Power Query and Power Pivot

This post shows how to hack DAX to display characters. Opens up some new possibilities.

 

Making Subtotals Bold

When you use the SUBTOTAL feature in the Data ribbon tab it automatically inserts subtotals in your list – see blog post on it here.

One problem with this is that is only makes the cell with the word Total bold – it doesn’t make the whole row bold.

If you want the whole row to be bold it isn’t hard to fix.

  1. Select the whole range involved.
  2. Use the grouping button 2 top left corner. See image below.
  3. Then hold the Alt key down and press the ; (semicolon key) – this selects just the visible cells.
  4. Then press Ctrl + b to bold it.
  5. Click another cell to reset the range and you are done.

Finding Those Pesky Links

Bill Manville

Thanks to Bill Manville for sharing the add-in.

This is a free add-in that’s been around for a long time and it finds most of those frustrating links that may have been created by

  • deleted files or folders
  • moved files or folders
  • renamed files or folders
  • sheets copied between files
  • charts copied between files

The add-in has been updated over the years so it now handles Power Query.

Printing Separate Print Areas

If you need to print a number of separate print areas from the one worksheet in one step there is an option that allows you to create a print area that includes additional ranges.

Create your first print area as per normal.

Select another print range and click the Page Layout ribbon and use the Print Area drop down and choose Add to Print Area. Keep adding ranges as you require.

You can also use the Ctrl key and mouse to select multiple separate ranges and then use Set Print Area.

The above technique allows you to add to that Print Area if you miss a range.

Downside

The only problem with this option is that each separate range is printed on a separate page(s).

Export a sheet as a PDF

It takes a few clicks but it is possible

I have previously posted about using CutePDF to create pdfs from Excel sheets. There is another way, but it takes a few clicks and it only works in Excel 2010 and later versions. (It may work in Excel 2007 but I have taken that version off my PC so I can’t test it.)