Mastering Visual Trends Analysis in Power BI
This post explains key methods for displaying changes over time in Power BI. It covers transforming date formats in Power Query, creating a date table, converting UNIX timestamps, and using visualizations like line graphs, column…
Who hates Power BI URL Parameters?
I love ’em, me, until I need to extract a custom URL – especially if it’s to this, this, this, and this – to share with others. With a bit of DAX and button trickery,…
Transform your data in PowerAutomate
Super-charge your automations in PowerAutomate by customising the data coming into it using Power BI’s query editor…
Power BI : Learn to build free Venn and Euler diagrams
Grouping datasets into overlapping circles can, in many cases, allow your audience to easily grasp relationships between them. Power BI comes a bit short in being able to deliver on this, with no out-of-the-box visualisations…
Easy Route to Hybrid Search in Sharepoint
Bringing content from applications that aren’t indexed by Sharepoint search can be expensive, complex, and fraught with unknown variables. Follow this guidance to quickly populate your index with such external content without having to go…
Power BI – Keeping it Simple
You know the scenario – you throw some visualisations together and publish a proof of concept. People love it, and start filling up your backlog. You quickly add new features accordingly, and before you know…
Sharepoint library settings – quickly go from default to awesome
The out of the box list settings in Sharepoint are simple and easy to get your head around. Here are some basic configuration settings that will bring out the very best Sharepoint has to offer.…
Power BI Toggle Switch visualisation updated
Sometimes it’s the little things that get me excited; so I was delighted to find out the Power BI toggle switch visualisation has been updated. This handy little graphic allows a user to click on…
Saving SharePoint Document Library/List Settings as a Template
Have you ever spent 20-minutes setting up a document library in SharePoint with multiple views, a folder structure, default column values, some custom columns, content types, and perhaps some default content, then struggled to copy…
What’s missing from the new Yammer?
The new version of Yammer is a massive improvement over the previous – full text and interactive emails, favouriting communities, the replacement of Yammer profiles with the Office 365 ones, and the hidden gem of…