Wise Owl blogs written by Sam Lowrie

Showing blogs 1-15 (out of 15)

How to monitor stock levels from forecast sales using DAX measures in Power BI

Posted by Sam Lowrie on 06 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!

Tags:   Power BI | Measures / DAX

A DAX formatter to tidy up your code

Posted by Sam Lowrie on 30 July 2018

Use this handy web based formatter to turn shameful code into neat DAX!

Tags:   Power BI | Measures / DAX

Debugging (sort of) in DAX

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!

Tags:   Power BI | Measures / DAX

How to show current drilldown filters in Power BI Desktop

Posted by Sam Lowrie on 20 July 2018

Some technique to remind users what levels they chose while using drilldown.

Stop automatic grouping in Power BI Desktop

Posted by Sam Lowrie on 20 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!

Tags:   Power BI | Visualisations

Disappearing data labels in Power BI Desktop

Posted by Sam Lowrie on 20 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.

Tags:   Power BI | Visualisations

Using MERGE and MATCHED in SQL

Posted by Sam Lowrie on 21 June 2018

Learn how to MERGE rows from two tables into one combined table, and how to remove unwanted data from both tables.

Tags:   SQL | Programming tables

Using the CROSS FILTER function in Power BI Desktop

Posted by Sam Lowrie on 13 June 2018

Learn about the perils of changing the cross filter direction to "Both", then discover why the CROSS FILTER function is better!

Tags:   Power BI | Measures / DAX

More suggestions for how to use bookmarks

Posted by Sam Lowrie on 09 June 2018

Another set of examples showing ways in which to use the weird and wonderful bookmarks feature in Power BI Desktop

Splitting long tables of data into different pages (pagination)

Posted by Sam Lowrie on 01 June 2018

This blog shows how you can split rows in tables into different pages, making the data easier to read.

Tags:   Power BI | Visualisations

How to create dynamic report titles in Power BI Desktop

Posted by Sam Lowrie on 01 June 2018

How you can combine the use of measures and cards to create dynamic report headers in Power BI Desktop.

Tags:   Power BI | Measures / DAX

Weighted and numeric distribution in Power BI Desktop

Posted by Sam Lowrie on 18 May 2018

Learn to use the SUMMARIZE and CALCULATE functions to produce numeric and weighted distributions.

Tags:   Power BI | Measures / DAX

Some suggestions for possible uses for bookmarks in Power BI Desktop

Posted by Sam Lowrie on 24 March 2018

This blog gives some suggestions for how you might use the new bookmarks feature in Power BI Desktop.

Learning bookmarks in Power BI Desktop

Posted by Sam Lowrie on 14 March 2018

You can use bookmarks to take your reports to the next level - they take a while to get used to, as this blog shows, but they're worth the hassle!

5 interesting custom visuals in Power BI Dektop

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!

Tags:   Power BI | Visualisations
This page has 0 threads Add post