Power BI

An ABC Analysis is a very common requirement for for business users. It classifies e.g. Items, Products or Customers into groups based on their sales and how much impact they had on the cumulated

For me the most exciting new feature in Power BI in a long while is the appearance of Query Parameters for data loading. We have been promised an official blog post explaining how they work (althou…

OK,   Played around with one of my datasets and I believe the following would work:   First Create a Summary Table based on the following pattern: Table1Summary = ADDCOLUMNS ( SUMMARIZE ( 'table1', 'table1'[task_type] ), "Count", CALCULATE ( COUNTA ( 'table1'[task_type] ) ) ) Then Create a C...

Power BI Desktop 2015 SU09 introduced a really cool new feature called calculated tables. Those of you who are already familiar with calculated columns will share my excitement since we now have a …

Technical introduction to Power BI limitations & considerations which hopefully will allow you to avoid most common implementation pitfalls.

Hello there   I've come out the other end of M is for (Data) Monkey and plenty of googling and mucking about to resolve this myself, but to no avail.  I'm hoping that you can help me.   I've a query (Timesheets) that lists timesheet entries for staff.  Each record holds a name and a date of the entr...

Microsoft released

Guest Post by Gil Raviv Intro by Avi: Many experts had proclaimed LongForm Journalism was headed towards extinction in the digital age. In fact it has found a new resurgence and a new audience in the

Today I wanted to share with you a Power BI dashboard that allows you to search in Linkedin for companies with certain specialty. To make it relevant

Hi there,   Interesting problem :smileyhappy:   I had a play with this and here is a sample solution in a PBIX file with source spreadsheet. https://www.dropbox.com/s/szg1uesipaxa15x/Foosey%20Greatest%20Ally%20and%20Nemesis.pbix?dl=0 https://www.dropbox.com/s/wodxj443py5xdk0/FooseyData.xlsx?dl=0   S...

As I mentioned in my blog

I have always been fascinated by maps as a child, and could spend endless hours looking at the globe my parents got me as a present for my 5th birthday. I was so hooked on to it that my parents eve…

Supereasy function using M in PowerBI or Excel (Power Query) to expand all selected Quandl time-series at once.

Microsoft's own Guy in a Cube has been providing tips and tricks for Power BI and Business Intelligence on his YouTube channel since 2014. Every Thursday we highlight a different helpful video from…

We want your dashboards and reports to instantly impress its audience, so the Microsoft Power BI team is offering the chance for a Dashboard and Report Makeover!

In this week’s Tech Tip Thursday, our own Guy in a Cube reviews the various ways you can share your Power BI content.

New Quick Insights capability allows you to search dashboard tiles for hidden insights automatically within seconds. Use Quick Insights to discover correlations, outliers, trends, seasonality, change points in trends, and major factors right from the dashboard tiles you are most interested in.

This week I was working on a project for a school up North. This customer wanted to use Power BI and map visualizations to view the locations of the various school buildings in the district. The pr…

Here is a common requirement that I have come across: “I want the Date slicer to automatically select current date without me having to manually change the slicer”. Here is a way to do that. We hav…

In this post you learn how Power BI and Google Maps API work together to do address lookup from geographic coordinates created by a GPS tracking device.

Official News from Microsoft’s Information Platform

Click the image for the interactive versionBrexit is a hot topic in the news these days over here in the UK. The ramifications are far and wide. Leaving the EU would mean a LOT of lost jobs,