Data & Analysis

How to Set Custom Color Themes in Microsoft Power BI

When publishing internal and external reports for your business it is important to be consistent with your branding standards by using the same color schemes and logos. Microsoft Power BI it a great tool for creating and publishing dynamic and interactive reports and it allows for…

18 June 2018

Data & Analysis

Time Intelligence Using DAX

Last week I presented a webinar with Chuck Sterling (from Microsoft) on the topic of Time Intelligence. This was a YouTube broadcast event that anyone could join live, however it has also been recorded and can be watched at any time (see below). Bron : Excelerator…

12 June 2018

Data & Analysis

Using Email Attachments As A Data Source In Power BI

Many of my customers get the source data for their Power BI reports – usually Excel or csv files – sent to them as an email attachment on a regular basis. When they get one of these emails what usually happens next is that they save…

11 June 2018

Data & Analysis

More Details On Creating Tables In Power BI/Power Query M Code Using #table()

About two years ago I wrote a blog post describing how the #table M function can be used to generate tables, but in that post I only covered the functionality I used regularly – namely using #table with a list of column names or a table…

1 June 2018

Data & Analysis

Dynamically Changing A Chart Axis In Power BI Using Bookmarks And Buttons

A very common requirement when building Power BI reports is to allow the end user to change what is displayed on a chart axis dynamically. A lot of people have blogged about how to do this – Kasper’s blog post here is a great example –…

28 May 2018

Data & Analysis

Adding a vertical line or marker to a chart in Power BI

A business user came to me asking “how can I get a vertical line on Line Chart in Power BI like my Excel report?”. I was like, “It’s straightforward. We have this analytics pane which lets you add so many types of lines ? “. But,…

25 May 2018

Data & Analysis

Working with Pivoted Data in Power BI

Oftentimes we have data in a format that is not suitable for creating visualizations in Power BI, for example, pivoted data. However, we still want to work with that data. Let us explore this in more detail. Suppose we have a table of data representing units…

24 May 2018