Toggle Measures in Power BI
Space on your dashboards is a limiting factor To make the best use of limited space setting up toggle measures in Power BI helps to use the space better One of the key challenges with dashboard building is finding the balance between detail and available space This article shows you how to combine a couple […]
Rolling Averages and Rolling Sums in Power BI
Why are rolling averages useful Rolling averages and Rolling totals are used when analysing data over time Rolling averages smooth out fluctuations across the number of periods Both of these are possible in Power BI if you know the steps involved How to create rolling averages in Power BI Power BI has a really helpful […]
What are Power BI Template Files?
What are Power BI Template Files Power BI report templates are a type of file that is designed to be the starting point for report creation, they are also known as .PBIT files due to their file extension or simply pbit files Power BI report templates contain all the components of a report, from data […]
Sparklines in Power BI
This short guide to sparklines in Power BI tells you what they are, how they can be very useful and how to add sparklines to your power BI reports What are Sparklines? Sparklines are a very compact, space efficient way to show a trend behind a headline number. This tells you whether to investigate further […]
How to use Power Pivot in Excel
Part 2 – Excel Power Pivot How to use Power Pivot in Excel for data modelling and analysis This follows on from our previous post How to use Power Query What is Power Pivot in Excel Power Pivot is a cutting-edge data modelling technology, It empowers you to create data models, establish relationships, and perform […]
Power BI RELATED Function
What is the Power BI RELATED function The Power BI RELATED function is a powerful tool that allows users to quickly and easily access related data from a related table It is similar in many ways to using lookups in Excel (VLOOKUP), Excel users wanting to learn this function will find the syntax fairly intuitive […]
How to use Power Query
How to use Power Query and Power Pivot for data modelling and analysis Whilst Power BI is known for its advanced data modelling and ability to transform data. You may not know that many of these functions are available in Excel. These Blogs aim to give you the knowledge or skills to use these, namely […]
Show Values in Rows in Power BI
This quick guide shows you how to show values in rows in the matrix visual in Power BI You will learn how to switch values on show in rows in a matrix, like this example The Matrix visual in Power BI is similar to a Pivot Table in Excel, but not quite as intuitive, which […]
Change the data source in Power BI
Sometimes you need to change the data source in Power BI from a static data source such as a CSV file to a SQL connection Here is an efficient way to do it to save you time and headaches This guide shows you a quick and easy way to make the change without having to […]
How to sort dates in Power BI
Working with dates can sometimes be a little challenging, this quick guide shows you how to sort dates in Power BI Its not always obvious how to do simple things like sort months in calendar or chronological order Here we show some simple tips using a date dimension table If you want to know how […]
