BLOGS BY TOPIC
BLOGS BY AUTHOR
BLOGS BY YEAR
Wise Owl blogs written in 2018 (page 1 of 2)
Showing blogs 1-20 (out of 37)
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!
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!
A summary of the new features in the July 2018 update to Power BI Desktop
Posted by Andy Brown on 25 July 2018
This month sees features allowing you to change the appearance of the icons at the top right of each visual, and also to change the appearance of the wallpaper surrounding a report, but otherwise all of the enhancements are fairly minor.
Five methods for creating partitions of SSAS Tabular tables programmatically
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.
Using partitions/processing to load a large fact table into a tabular data model
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.
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!
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.
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.
Some ideas for company days out!
Posted by Andy Brown on 18 June 2018
Go-karting, axe-throwing, escape rooms and ninja training - some of the ideas from this blog suggesting company days out in Manchester.
A summary of recent blogs that we've written on bookmarks in Power BI Desktop
Posted by Andy Brown on 18 June 2018
We've created a few blogs giving some ideas for how to use the new Power BI bookmarks features (including dynamic charts and enabling pagination). This blog brings the links together onto a single page.
Resolving a problem with SSRS and a Windows 10 update
Posted by David Wakefield on 18 June 2018
After installing Windows 10 our laptops started returning a 503 error in Web Portal - this blog shows how to resolve this.
How to get the custodians of your data to give you access!
Posted by David Wakefield on 18 June 2018
GDPR isn't as restrictive as most commentators claim, as this blog sets out to show. Don't let data custodians block you from analysing your corporate data!
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!
Changes in the June 2018 Update of Power BI Desktop
Posted by Andy Brown on 09 June 2018
There are hardly any changes in this update - the only significant one is that you now sort and filter data within Power BI Desktop itself, rather than having to go into Query Editor.
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.
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.
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.
A summary of new features added to Power BI Desktop in the May 2018 update
Posted by Andy Brown on 14 May 2018
New features introduced into Power BI Desktop in this update include conditional formatting by different fields, the inclusion of filters in drill-through and minor improvements to line and funnel charts.