Posted by
Andrew Gould
on 07 September 2024
Not every set of data you want to import from a web page is considerate enough to exist as an HTML table. Fortunately, you can give examples of the information you want to import to have Power BI infer a table from the data on the page.
Posted by
Andy Brown
on 05 September 2024
If you're a qualified pilot (but also a bit of a data nerd) how do you keep track of your flights? With a Power BI report, of course!
Posted by
Andy Brown
on 05 September 2024
Most of the changes in the July and August updates to Power BI are either too insignificant to merit a write-up here or else are for features in preview. For most report-writers the ability to document DAX measures is the only change which will make much difference in these two updates.
Posted by
Shaun Wantling
on 09 July 2024
A method for using Drill through in Power BI with multiple categories.
Posted by
Andy Brown
on 20 June 2024
This month's update to Power BI Desktop adds some seriously arcane functions to DAX, but it's the roll-out of the Power BI Home feature which most people will notice.
Posted by
Andy Brown
on 04 June 2024
The PQ How site contains both a reference guide to the M language and lots of links and resources for articles which will help you to learn it.
Posted by
Andy Brown
on 04 June 2024
We thought it might be useful to share the theme that we use for some of our reports, with some annoations, to give you an idea of what's possible when setting default Power BI formatting
Posted by
Andy Brown
on 04 June 2024
This month's bigger than average update sees new pivot table style matrix layouts, the emergence of modern tooltips, calculation groups and the DAX query pane from preview and a couple of other smaller changes.
Posted by
Andy Brown
on 07 May 2024
The April 2024 Power BI update includes a new 100% stacked area chart visual and some minor new line chart formatting options - but still none of the big beasts lurking in preview!
Posted by
Andy Brown
on 04 April 2024
On-object interaction remains stubbornly in preview in Power BI, but it's been steadily updated since we last blogged about it, so we felt it was time for this catch-up.
Posted by
Andy Brown
on 28 March 2024
There are updates to on-object interactions and visual calculations this month, but these major new features still remain in preview. This leaves small changes to data bar and data label formatting - and a new way of doing row-level security - as the only signficant changes in this month's update.
Posted by
Andy Brown
on 04 March 2024
The only big change in the February 2024 update to Power BI Desktop is that "Power BI Home in Desktop" is now enabled by default, but the exciting new visual calculations feature is also now waiting in preview.
Posted by
Andy Brown
on 04 March 2024
Two little tricks to change the order of columns in SQL Server Management Studio and Power BI Query Editor, which (to our shame?) we've only just discovered.
Posted by
Andy Brown
on 04 March 2024
The Azure map visual has been an official part of Power BI now for nearly a year, and the initial teething problems have now been ironed out. This blog shows how to use the Azure maps visual, and explains why you don't now need to use any of the other map visuals in Power BI.
Posted by
Andy Brown
on 01 March 2024
Power BI is a nightmare to teach, as it keeps changing! Our policy is to update our courseware roughly every 18-24 months; this blog contains details of our latest huge update, and how it will affect delegates on our Power BI courses.
Posted by
Andrew Gould
on 23 February 2024
The February 2024 update to Power BI has an interesting new preview feature: visual calculations. These allow you to create DAX calculations within individual visuals in a report. This blog shows why that's useful!
Posted by
Andy Brown
on 09 February 2024
A series of steps that you can follow to convert UK format postcodes into latitude and longitude data for use in Power BI Desktop visuals.
Posted by
Andy Brown
on 31 January 2024
This update includes lots of updates to the formatting of bar/column charts, even more data label formatting options and better clustered bubble chart formatting for Azure Maps.
Posted by
Andy Brown
on 31 January 2024
It's time to bite the Power BI bullet and revamp our courseware (our last update was nearly two years ago).
Posted by
Andy Brown
on 11 December 2023
Although the main innovations in this update are in preview, two of them are turned on now by default: button slicers and reference labels for cards. We also can't resist the temptation to show the new DAX query view, even though it's still very much in preview only.