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 →

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 →