Information Handyman
Struggling with incorrect data in Power BI reports? This article offers a clear, step-by-step workflow to identify and resolve issues like missing values, duplicate columns, and mismatched relationships. Learn how to ensure your reports are accurate and reliable. Don’t miss the handy cheat sheet included!
This article is a must-read for anyone using SharePoint lists to manage tasks and actions. It guides you through transforming your raw data into insightful visualisations that can help you track team performance, identify resource bottlenecks, and stay on schedule.
Want to build trustworthy Power BI reports? This article emphasizes the importance of branding, storytelling, standardizing footers, thorough documentation, clear commenting, and validating metrics. These practices ensure reports are accurate, auditable, and resilient, fostering confidence and trust among stakeholders.
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 graphs, area charts, Gantt charts, and histograms. The post also provides steps for accurate running totals and highlights both DAX and simpler solutions.
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, however, there’s a way to add a button to a page so once values are selected in a slicer, the […]
Super-charge your automations in PowerAutomate by customising the data coming into it using Power BI’s query editor…
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 for Venn or Euler graphs – and the custom visualisations are lacking essential features or cost up to US$5,000 p/annum. […]
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 it you’ve an unintelligible mass of pages, charts, tables, filters, maps, and text boxes; the ‘love’ turns out to be […]
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 it to filter the data in other visualisations to a value, or values, that you specify in the options; and […]
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 closing posts to further comments have been met with universal acclaim. I’m not here to gush, however, so lets get […]