Power BI

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,

The Breakdown tree makes it possible to visually display the full drill-down path of a measure. By keeping all levels in the drill-down path visible you will get a good overview of how your numbers

When you create a data model in Power BI, you should consider how to properly use naming convention and what columns to include, in order to improve usability and performance. This article provides a