This week, I got an interesting question about Power BI: “Can I format a specific cell or row in a table or matrix?” My answer was yes and I thought it could be a great blog. Let’s say, you need to format the Sales Amount for all countries as a whole number, except for Australia. … Continue reading Power BI: How to format a specific cell or row in a table or matrix?
Power BI July 2019 version, released on: 18th of July- 2.71.5523.821 24th of July - 2.71.5523.941 Here’s the complete list of July updates: Reporting Icon sets for table and matrix Percent support for conditional formatting by rules New filter pane is now generally available Data colors support when using play axis on scatter charts Performance … Continue reading Power BI – July 2019
Power BI October 2018 version, released on: 15th of October - 2.63.3272.40262 Here’s the complete list of October updates: Reporting Search in filter cards Improved accessible authoring experiences Performance improvements for ArcGIS Map Modeling DAX editor improvements Analytics Composite models & Aggregation support in the Power BI service (preview) Explain the increase for non-additive measures … Continue reading Power BI – October 2018
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
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
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
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