BLOGS BY TOPIC▼
BLOGS BY AUTHOR▼
BLOGS BY YEAR▼
You can now search for formatting properties, have slicers which work across pages and create quick measures, among other new features.
- Power BI Desktop - February 2018 update new features
- Search for a formatting property
- Quick Measures
- Synchronising slicers across report pages
- Multi-select data points in a chart
- Overflow data labels
- Marking date tables as such (this blog)
- Extra DAX functions
- 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:

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:

Choose to mark this as a date table!
Choose the column in your table which gives the unique date for each row:

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!
- Power BI Desktop - February 2018 update new features
- Search for a formatting property
- Quick Measures
- Synchronising slicers across report pages
- Multi-select data points in a chart
- Overflow data labels
- Marking date tables as such (this blog)
- Extra DAX functions
- Features still in preview as of February 2018