Posted by
Andy Brown
on 06 November 2024
We've silently added a fair few blogs on Power BI in the last couple of months - this short blog gives a useful index to them.
Posted by
Andy Brown
on 05 November 2024
You can now create data-bound reference layers in Azure maps, document your model's measures, tables and columns using the INFO.VIEW function in DAX, format chart markers within inches of their lives and apply dynamic formatting using DAX.
Posted by
Sam Lowrie
on 31 October 2024
Pull through the official list of Bank Holidays in the UK.
Posted by
Rick Gould
on 22 October 2024
Although Power BI allows you to display values as a percent of the grand total, you can't conditionally format this directly. Fortunately, you can use a measure to solve the problem.
Posted by
Sam Lowrie
on 30 September 2024
Updating a measure definition is easy but what happens when you have 200 to update? This blog guides you through using the Dax Query View to achieve this.
Posted by
Andy Brown
on 26 September 2024
This month Power BI Desktop gets a new dark mode! Visual calculations and visual level format strings have also been turned on by default (although both remain in preview, strangely).
Posted by
Sam Lowrie
on 23 September 2024
Use Power Automate to pull data from Power BI using a DAX query.
Posted by
Sam Lowrie
on 09 September 2024
Add report refresh date
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
Sam Lowrie
on 09 September 2024
When using more complex measures there may be a need for each to be formatted differently. This blog shows you how to use the dynamic formatting measure feature.
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.