Power BI – January 2018

Power BI January 2018 version, released on: 8th of January - 2.54.4970.761 18th of January - 2.54.4970.961 Here’s the complete list of January features: Reporting Show and hide pages Control data label background color for Cartesian and maps visuals Increase area used for axis labels in charts Bar/column padding control Show dates as a hierarchy … Continue reading Power BI – January 2018 →

Power BI – December 2017

Power BI December 2017 version, released on 11th of December. Here’s the complete list of December features: Reporting Q&A for report creation (preview) Cross-highlighting for bookmarks More bookmark flexibility Field properties pane and field descriptions Scatter visual from x- & y-axis groupings High density sampling for maps based on latitude and longitude Responsive slicers New … Continue reading Power BI – December 2017 →

Power BI previous versions

See below a list of Power BI previous versions since 2017: January - December 2022 January - December 2021 January - December 2020 December 2019 November 2019 October 2019 September 2019 August 2019 July 2019 June 2019 May 2019 April 2019 March 2019 February 2019 January 2019 December 2018 November 2018 October 2018 September 2018 … Continue reading Power BI previous versions →

Power BI World Tour Sydney – Real-Time Streaming in Power BI

This week I presented Real-Time Streaming in Power BI at Power BI World Tour in Sydney for over 120 people. In this session I presented: Power BI Push dataset; Streaming dataset; PubNub dataset; Overview of Microsoft Flow & Cognitive ServicesDemo face recognition (Face API) with Flow & Power BI;Overview of Azure IoT Hub and Stream … Continue reading Power BI World Tour Sydney – Real-Time Streaming in Power BI →

Power BI World Tour 2017

Next month, I will be presenting Real-time streaming in Power BI at Power BI World Tour in Sydney. The conference starts on the 6th of November and will provide 2 days of technical training in Power BI. In my session, I will cover the following topics: Types of real-time datasetsHow to push data to datasetsSetup … Continue reading Power BI World Tour 2017 →

Power BI – Importing Multiple Excel Sheets

Last week, I received an Excel file with hundreds of sheets and I had to import it to Power BI. The Excel spreadsheet had one sheet per day, as below: When I tried to import it, I realized that a lot of people may have the same requirement and I decided to write this post, … Continue reading Power BI – Importing Multiple Excel Sheets →

Power BI previous versions

Every month Microsoft releases Power BI updates, which is great as every month new features are added to Power BI. In the last 18 months, I have tried to keep a copy of all Power BI versions, so if anyone needs to use a previous version you can download from the table below. Power BI … Continue reading Power BI previous versions →

Power BI – Working with Date – Part II

In the previous post (Working with Date – Part I), I wrote about calculated column for month and year and in this post I will explain how to work with day and week formats. As prerequisites, your Power BI model needs to have a Date table, which will be used to create a couple of … Continue reading Power BI – Working with Date – Part II →

Power BI DAX Percentage

There are a couple of ways in Power BI to create a chart to show percentage and I am writing this post to show few different ways to accomplish it. I am using a few tables from AdventureWorks 2016 CTP3 database, as below: For testing propose, I will use Line Total (Sales Order Detail Table) … Continue reading Power BI DAX Percentage →

Power BI – Working with Date – Part I

I have been working with Power BI for few years and quite often someone asks me questions about Date functions in DAX (Data Analysis Expressions), that is the reason I am writing this post. As prerequisites, your Power BI model needs to have a Date table, which will be used to create a couple of … Continue reading Power BI – Working with Date – Part I →