Report Building
3 Things to do when handing a Power BI report / model for Report Personalisation As a powerbi developer you know your data and your model inside out. Part of my role as an external consultant is to train people in using their reports and increasingly how to use the dataset in different scenarios and […]
Quick Books Online to Power BI to Excel
How to Connect Quick Books Online (QBO) to Power BI and then to feed into Excel To connect to Quick Books using Power BI you need a specific connector: https://docs.microsoft.com/en-gb/power-query/connectors/quickbooksonline To enable authentication to Quick Books, you need to: Download the new Microsoft Edge based on Chromium You then need to go into your Environment […]
Power BI Infographics and Icons
The ability to look at your data and enable your users to visually comprehend the story can be improved with the use of icons and graphics. On this Power BI chart we use icons to represent Nobel Peace Prize winners. To give an overview the data is grouped into tens with the female winners coloured […]
Power BI Gantt Chart, Tooltip and Drillthrough
The ability to look at summarise data into a meaningful image on a screen but then to use that to drill through for more detail when required is incredibly useful and very powerful. This example shows a Gantt chart summarising the Olympic Events happening in Japan based on UK times. The data is summarised on […]
Power BI Age Pyramid
Power BI Age Pyramid The ability to look at your data and then predict the likelihood of what is going to happen is incredibly useful in making business decisions. This is one method that Power BI uses to show data changing over time. It’s using two custom visuals. One is an age pyramid which allows […]
Highest and Lowest Values
Power BI Report using Calculation Groups to switch different measurements You will also note that the countries are separated out using the small multiples visual allowing the information to be clear and easily understood. This second page of this report allows the user to also then choose which measurement they want to look at – […]
Time Intelligence Example Showing Trends In US Housing Market
Power BI Time Intelligence When you have data that has a date most businesses want to able to see trends from previous years, quarters, months, weeks or days to give context to the measure that they are considering. For example: Did we do better than last year? What impact has the advertising over the past […]
Bookmarks
Bookmarks Bookmarks are an excellent way to keep your reports simple and uncluttered whilst giving your users additional information when they use it. For example, if you click on the ‘i‘on this report, it places an overlay on the page which gives the supporting information. I found them a little hard to get my head […]
Creating a printable list using Power BI, Excel and a little bit of VBA
Frequently my clients love the visualisation and aggregation of Power BI but want to be able to print off a scrollable list. However, this is one key element that is not part of Power BI, you need to use paginated reports which is included within Premium licensing. Paginated Reports give the ability to create a printable report on several pages of a table. […]
Creating KPIs in Tabular Editor that work with a Selected Measure
I have been experimenting with Tabular Editor and Power BI Desktop for a few months now and looking at and using Tabular Editor to create KPIs. The tutorials that I used are Creating KPIs in Power Bi Desktop, Tabular Models for Power Bi & Excel both from SQLBi.com, and Calculation Groups with Tabular Editor from […]