WiseOwl Training - Established 1992 Wise Owl Training

Established May 1992
30 years in business
Wise Owl Training
30 years in business
See 529 reviews for our classroom and online training
Read about the many new features introduced in the March 2019 update
Part five of a ten-part series of blogs

This is the biggest single update for some time, introducing the new modelling view, tooltip styling, single-select slicers and much more besides.

  1. The March 2019 Update to Power BI Desktop
  2. A new modelling view to change your Power BI life!
  3. Changing the appearance of tooltips
  4. Single-select slicers
  5. Viewing date components in the field list (this blog)
  6. Automatic heat maps and improvements to map formatting
  7. Improved selection pane
  8. New DAX functions
  9. Lots of other miscellaneous changes
  10. Power BI features waiting in preview, as of March 2019

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 20 March 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.

Viewing date components in the field list

Another very welcome (and overdue) change - you can now see the parts of a date hierarchy in the field list:

Expand date hierarchy

The symbol shown appears to the left of any date field automatically.


When you click on the symbol above, you see the date hierarchy:

Date hierarchy

Just one more click to go ...


When you click on this symbol you can choose which parts of a hierarchy to show:

Choosing year, quarter, etc

You can choose whether to show the year, quarter, month and/or day for this field.


In the chart below I just ticked the Quarter level of the hierarchy:

Chart by quarter

This chart just shows the number of films by quarter (disregarding the fact that they were released in different years).


Unless you want to create time-intelligence functions (for example comparing this year's sales with the previous year's), there's ever less reason now to add your own calendar to a data model.

This blog has 0 threads Add post