Posted by
Andy Brown
on 11 December 2024
Last month we asked you to come up with a series of Power Query transforms to massage some data into football league format, and only three people answered the call!
Posted by
Andy Brown
on 06 December 2024
This month sees a few new preview features (of which we've chosen to highlight list and text slicers), but only two release changes: paths in Azure maps, and the ability to create new measures in DAX queries.
Posted by
Andy Brown
on 06 December 2024
Not before time, we've updated our Power BI Desktop skills test to the latest version. It's interesting to look back at the original test to see just how much has changed!
Posted by
Andy Brown
on 06 December 2024
A new single page summarising planned improvements to visuals and other display items in Power BI Desktop
Posted by
Sam Lowrie
on 02 December 2024
Icons can add a little extra something to your reports. Working out how to do this using JSON files is tricky and in this blog we will cover how!
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.