Posted by
Andy Brown
on 22 March 2021
How can you highlight the row in a table corresponding to the slicer value you've chosen? With a disconnected slicer and a clever measure!
Posted by
Andy Brown
on 22 February 2021
Be careful of referencing measures in calculations when you have duplicate rows in a table! This blog explains why you might want to hang on to that unused primary key column.
Posted by
Andy Brown
on 22 January 2021
How can you show each aggregate value in a group as a percentage of the highest aggregate value? This blog shows two ways to use DAX measures to solve this deceptively difficult problem.
Posted by
Andy Brown
on 14 January 2021
Did you know that you can write an EVALUATE DAX query in software like DAX Studio and then run it from within Power BI to create a new table? You do now!
Posted by
Andy Brown
on 23 December 2020
Puzzled as to why there are two near-identical versions of Power BI Desktop? Wondering if web portal is anything like Power BI report server? Confused as to what a paginated report is? This blog answers all these questions, and more!
Posted by
Andy Brown
on 02 December 2020
Inspired by a question from a course, in this blog Andy Brown builds up a measure to show cumulative totals for a calendar matrix, dotting his DAX i's and crossing his t's!
Posted by
Andy Brown
on 27 November 2020
This awesome game shows what's possible using bookmarks in Power BI (think of it as the sequel to Sam's 2019 Pin the Tail on Rudolf game).
Posted by
Sam Lowrie
on 30 October 2020
This blog show two ways in which you can create custom themes in Power BI without needing to learn how to write JSON: either use the built-in theme editor in Power BI, or use the theme generator from Power BI Tiips.
Posted by
Andy Brown
on 24 October 2020
What do you get when you combine the futuristic 3-dimensional mixed-reality environment created by the HoloLens 2 headset with Power BI reports? Read this blog to find out!
Posted by
Andy Brown
on 24 October 2020
Following a question from a recent DAX course, here are 3 recommended YouTube tutorial channels to help you learn to master DAX.
Posted by
Andy Brown
on 08 August 2020
Sadly we do occasionally make mistakes in our training, but when this happens we always try to correct them. Here, we explain that Power BI report page tooltips can in fact be any size.
Posted by
Andy Brown
on 15 November 2023
This month's modest update allows you to use Excel financial functions in DAX, show a gradient legend and change your slicer header, among other minor changes.
Posted by
Sam Lowrie
on 26 June 2020
Sam was tired of getting told off for crinkled or missing expense receipts. So he had a look at Power Apps and this is what he found…
Posted by
Andy Brown
on 27 April 2020
The ComicGen custom visual allows you to show one of two characters (Dee or Dey) in a variety of poses, and with a range of emotions. Excitingly, the poses and emotions can depend on your data, making these the most human of KPIs. Find out more in this blog!
Posted by
Andy Brown
on 12 March 2020
This modest blog explains how you can tell Power BI to show all of the members of a dimension table (even the ones which have no corresponding data).
Posted by
Andy Brown
on 13 February 2020
Simple Talk provide excellent how-to guides on any aspect of Microsoft software. We are proud to have contributed a series of articles explaining how to create DAX calculated columns and measures within Power BI.
Posted by
Andy Brown
on 10 January 2020
When we find new features which we didn't know about, we try to share them! Did you know that you can turn preview off when getting data? Or that you could left-click to drill-through? We didn't!
Posted by
Sam Lowrie
on 08 November 2019
This blogs shows a clever way in which you can use a slicer to choose which values to compare in a measure.
Posted by
Sam Lowrie
on 28 October 2019
The RANKX function does what the name implies - it ranks values based on a calculation. However, the VALUE argument often causes confusion; this blog explains what it does!
Posted by
Andy Brown
on 18 October 2019
Power BI improves with each monthly update. Will it reach a point where SSRS (SQL Server Reporting Services) becomes redundant? This detailed blog compares the two products, and considers the future of SSRS.