WiseOwl Training - Established 1992 Wise Owl Training

Established May 1992
30 years in business
Wise Owl Training
30 years in business
See 525 reviews for our classroom and online training
New features in the February 2018 update of Power BI Desktop
Part seven of a nine-part series of blogs

You can now search for formatting properties, have slicers which work across pages and create quick measures, among other new features.

  1. Power BI Desktop - February 2018 update new features
  2. Search for a formatting property
  3. Quick Measures
  4. Synchronising slicers across report pages
  5. Multi-select data points in a chart
  6. Overflow data labels
  7. Marking date tables as such (this blog)
  8. Extra DAX functions
  9. Features still in preview as of February 2018

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 15 February 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.

Marking date tables as such

You can now explicitly tell Power BI Desktop to use a calendar table that you've imported as a date table.  To do this, first import a table containing a date key:

Calendar table

Here the date key field is - conveniently - called DateKey.  No two rows can have the same value for the date key, and each date appears once and once only.

With this table selected, choose the following option on the extreme right of the Modelling tab of the Power BI Desktop ribbon:

Mark as date table

Choose to mark this as a date table!

Choose the column in your table which gives the unique date for each row:

Date key column

Choose the column which contains a different date for each row of your table.

If - like Wise Owl - you always import your own data table, rather than using the built-in ones that Power BI Desktop supplies, you'll wonder what you've gained by the extra step shown above!

This blog has 0 threads Add post