WiseOwl Training - Established 1992
We're excited to announce that from 14th April we'll be running live online training courses too!
From 14th April we'll be running live online training courses too!
This page has 0 threads   |  Add post
Five star reviews Outstanding course feedback
Average score 9.33 out of 10, based on 9087 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

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

  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
This blog has 0 threads Add post