Johan Vermeire 42 blogposts

Power BI tip: Use folders to structure your measures

Johan Vermeire
28/09/2021

In many Power BI datasets, you’ll notice a separate table containing measures.  While this isn’t really necessary, it can be useful.

The downside is that as the number of measures grows, this table will be absolutely flooded with measures, which makes it hard to find the measure you need.

The usual solution for this problem is creating folders in the table... but at first sight, it looks like you can only create folders at the table level, not within the folders themselves.  It is possible, though - if you know how.

How to hide zero values in an Excel worksheet

Johan Vermeire
27/04/2021

If a worksheet contains rows upon rows of numbers, things can look quite cluttered. 

As you can see in the example above, the large number of zero values draws the eye away from the fields that contain actual data.  

One of the tricks to make the worksheet look less chaotic is by simply not showing the zero values. There are several ways to do this in Excel. 

How to ‘glue’ bits of text together

Johan Vermeire
20/04/2021

Excel has multiple functionalities that combine text from several cells into one big text. This is called ‘text concatenation’. In the examples below, we’ll assume our table includes the following columns: Street, Number, Postal Code and City.

What are data categories in Power BI?

Johan Vermeire
09/03/2021

During our trainings for new Power BI users, we often notice that they don’t always realise how much creating a correct data model could help them. For example:

  • Data are read quicker
  • Calculations are executed faster

People often import data straight from the source into the model, map out the necessary relationships and start creating the visuals.

Power BI - Optimising memory: how to merge tables

Johan Vermeire
09/09/2019

In this blog series, we’ll explore some easy ways to reduce the size of a Power BI model. This blog post teaches you about merging tables.

Power BI - Optimising memory: how to split columns

Johan Vermeire
02/09/2019

In this blog series, we’ll explore some easy ways to reduce the size of a Power BI model. This blog posts teaches you how to split columns.

Power BI - How to optimise your memory: removing unneeded fields

Johan Vermeire
26/08/2019

In this blog series, we’ll explore some easy ways to reduce the size of a Power BI model. In this blog post I will tell you why you should remove some fields.

Power BI - Optimising memory: date tables

Johan Vermeire
19/08/2019

In our previous blog post, we explained how we can use VertiPaq Analyzer to analyse the amount of memory our model needs.  This memory is also linked to the speed with which the model calculates and refreshes data. In this blog series, we’ll discuss several ways to limit this memory usage.

Power BI – Check a model’s memory usage with VertiPaq Analyzer

Johan Vermeire
07/08/2019

One of the things you could do to refresh your data quicker and speed up calculations is resizing the data model. But how do you even figure out the current size of your data model? Is it the same as its file size?  

UserVoice: Take part in decisions about your favourite Microsoft application(s)

Johan Vermeire
28/08/2018

In the past, a new version of Microsoft Office was released every few years. Office 365 is different: it only has one version, which is updated regularly. Whenever a new Office version came out, we – as trainers – were curious to see the new functionalities Microsoft had integrated into the software. It made us wonder: “What will Microsoft come up with next time?” Well, they’ve still got plenty of inspiration!

Bring your knowledge and skills to a higher level

Subscribe for our monthly newsletter and receive:

  • Exclusive tips & tricks
  • Information about our courses
  • Trends on courses
  • Invitations to seminars and events

Most popular courses