BLOGS BY TOPIC
BLOGS BY AUTHOR
BLOGS BY YEAR
Wise Owl Blogs - Home (page 1 of 20)
Showing blogs 1-20 (out of 385)
Posted by Andy Brown on 18 April 2019
The April 2019 update to Power BI introduces a new concept: the ability to make the value of a property dynamic. Other welcome new changes include M Intellisense, data profiling in query editor and cross-report drill-down.
Posted by Andy Brown on 29 March 2019
Someone has finally won our competition to think of a better acronym for the order of keywords in SQL, we're pleased to announce.
Posted by Andy Brown on 21 March 2019
In addition to all of the wonderful new features in the March 2019 Power BI update that I blogged about yesterday, you can also create multiple database relationship diagrams (or layouts).
Posted by Andy Brown on 20 March 2019
This is the biggest single update for some time, introducing the new modelling view, tooltip styling, single-select slicers and much more besides.
Posted by Andrew Gould on 19 March 2019
Power BI encourages you to publish reports to an online service so that you can share your beautiful reports with the world. If you'd rather keep them a secret you can use Power BI Report Server to deploy your reports to an on-premises server, as this blog series shows you.
Posted by Sam Lowrie on 25 February 2019
Context transition happens when a DAX function creates filter context within row context, or vice versa. This blog explains what context transition is, and shows which DAX functions make use of it.
Posted by Andy Brown on 15 February 2019
There wasn't an official January update, although there were improvements announced to Power BI Service. This blog lists these, and also new features to wrap titles in visuals, apply rounded corners and change the default way in which visuals interact with each other.
Posted by Sam Lowrie on 01 February 2019
Row context (along with its sibling, filter context) is one of the most important concepts in DAX. This blog explains what row context is, and how to use it!
Posted by Sam Lowrie on 28 January 2019
Understanding filter context is the key to understanding how to create measures in DAX. This blog aims to explain this vital subject as succinctly as possible!
Posted by Andy Brown on 03 January 2019
This blog shows how to create fully dynamic reports, whereby users can choose which statistics to show and which dimensions to report them by.
Posted by Andy Brown on 13 December 2018
This is a small update, but a very welcome one! You can now (finally) zoom in the DAX editing window, and also use smart guides to align visuals. There are also other minor cosmetic and keyboard updates.
Posted by Andy Brown on 06 December 2018
Following a question from a Power BI course, this blog shows how you can get a page to show the top N customers by sales value, where N is a number controlled by a slicer.
Posted by Andy Brown on 26 November 2018
A big new update this month, including expandable row headings in matrices, copying and pasting between visuals and conditional formatting of charts (although it's what's waiting in preview which will really blow your mind).
Posted by Sam Lowrie on 06 November 2018
Given your current stock levels and forecast sales, it should be possible to report on future stock depletion in Power BI. This two-part blog shows you how to just that!
Posted by Andy Brown on 23 October 2018
If you're lucky (?) enough to live in the United States, you won't have a problem with shape map files; if you live in the UK, you may find these links useful!
Posted by Andy Brown on 19 October 2018
Not an earth-shaking update, but lots of nice new features nonetheless to make your life easier, including a better DAX editor, the ability to search for text when filtering a visual and a clever new connector which guesses what you want to import from a website.
Posted by Andy Brown on 21 September 2018
The September update of Power BI finally breathes life into report page tooltips, which have been in limbo for a while. You can also copy data from Power BI reports by right-clicking, use some keyboard short-cuts for visual design, apply built-in themes, set fixed-width padding by column example and show categories on the X axis of scatter charts.
Posted by Andy Brown on 21 September 2018
A (very) short blog containing a link to an article showing how you can import data from Access using SSAS or SSIS on a 64-bit computer
Posted by Andy Brown on 14 August 2018
This is a bigger update than most, largely because it includes two major new features emerging from preview (report themes and desktop Q&A), but it's the export to PDF feature which really catches the eye.