Creating custom visuals using the Charticulator in Power BI is not easy. So here are some some Charticulator resources I’ve used to skill up.
In late 2021, the Charticulator visual was added to Power BI desktop. This post walks through creating a Charticulator Simple Custom Chart. The chart will show the drink preference split of 20 office colleagues. The steps assume you already have connected to the data. The data is available for download or direct connection here: https://hatfullofdata.blog/wp-content/uploads/2021/12/Drinks.xlsx YouTube Video It's coming! Adding...
I have a report, Open Issues, that has a Power BI dataflow as a data source. If I just use scheduled refreshes, my options are limited. I need to be refreshing datasets automatically after the dataflow has finished so my reports are up to date as soon as possible to avoid a situation where I schedule the dataflow to refresh...
In nearly every business across the world, staff give reports to managers. How many people assess the report cost? The reports will show how well or badly the business is performing. Accurate reporting is important in every organisation. Management needs to be able to make data-driven decisions.
In this post I will describe how to get previous row data that matches a criteria. This post will demo getting a person’s previous score.
This is the first post in a series to create a Star Wars report. This post handles the issue of using a parameter as the url in a web Power Query. This type of data source is referred to as a Dynamic Data Source. It will not refresh in the Power BI service unless you do some tricks. Fetching Data...
This post is to document how to use Excel VBA to edit a parameter value without using the a cell reference in Power Query.
Dataverse is a secure flexible data storage solution that is part of the very popular Microsoft Power Platform family. So connecting to Dataverse is an obvious request. Dataverse was previously known as Common Data Service. This post is from getting very frustrated mid-hackathon and trying to connect to Dataverse and just getting an odd error. If you want to learn...
Important Update! On 14th Nov 2022 Microsoft announced that Paginated reports will no longer require premium capacity and can be created with a Power BI Pro license. Here is a link to the article https://powerbi.microsoft.com/en-us/blog/announcing-support-for-paginated-reports-in-power-bi-pro/ Introduction Here are resources to help you learn how to use Paginated reports. You will need a premium capacity or Premium per user license. If...
This post is to support my virtual session at London Microsoft Reactor on 1st Feb 2021. The session is an introduction to Power BI using sales data for 2020 from an imaginary gift shops. YouTube Recording Resources The Excel file used as the data can be found at:https://hatfullofdata.blog/wp-content/uploads/2021/01/Sales.xlsx The background image used in the demo can be found at:https://hatfullofdata.blog/wp-content/uploads/2021/01/Gift-Background.png The...
