Posted by
Sam Lowrie
on 25 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 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
Sam Lowrie
on 05 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
Sam Lowrie
on 30 July 2018
Learn to use DAX variables, and understand how they can be used to break up code. Not true debugging, but better than nothing!
Posted by
Andy Brown
on 23 July 2018
Need to generate a partition for a fact table for each year, product or region? This blog gives five approaches, so that you can choose which method is for you.
Posted by
Andy Brown
on 23 July 2018
This blog shows how you can load the empty structure of a large fact table into an Analysis Services tabular data model, then use partitions to bring in the data bit by bit.
Posted by
Sam Lowrie
on 18 July 2018
Some technique to remind users what levels they chose while using drilldown.
Posted by
Sam Lowrie
on 18 July 2018
Read this blog to understand the risk of Power BI's automatic grouping of data, and to learn how to avoid getting caught out!
Posted by
Sam Lowrie
on 18 July 2018
Ever had a data label vanish for no apparent reason? This blog gives two of the most common reasons why this might happen.
Posted by
Sam Lowrie
on 19 June 2018
Learn how to MERGE rows from two tables into one combined table, and how to remove unwanted data from both tables.
Posted by
Sam Lowrie
on 11 June 2018
Learn about the perils of changing the cross filter direction to "Both", then discover why the CROSS FILTER function is better!
Posted by
Sam Lowrie
on 30 May 2018
This blog shows how you can split rows in tables into different pages, making the data easier to read.
Posted by
Sam Lowrie
on 18 May 2018
Learn to use the SUMMARIZE and CALCULATE functions to produce numeric and weighted distributions.
Posted by
Sam Lowrie
on 12 March 2018
Basic Power BI Desktop visuals can leave something to be desired. Try these 5 visuals to spice up your reports!
Posted by
Andy Brown
on 16 February 2018
There seems to be an occasional bug in Report Builder which fills a table with blank rows. Here's one owl's way to get round it.
Posted by
Andy Brown
on 16 February 2018
Report Builder and SQL Server Reporting Services are almost identical - which makes the small but important differences even harder to explain.
Posted by
Andy Brown
on 16 February 2018
You can use the IIF function in SQL as an alternative to the CASE WHEN statement. We thought we would share this new (for us) discovery with the world!
Posted by
Andy Brown
on 29 January 2018
If you're trying to project your screen at the front of a class, the Windows Magnifier lets people see what you're doing more easily.
Posted by
Andy Brown
on 04 January 2018
If you get data in pivot (two-dimensional) form, you can unpivot it to get the underlying rows, and hence produce charts and visuals. This blog shows how!