Power BI

Utilizing Power Query Lists 2/3 This article is part 2 of the Using Power Query lists series. In this series, we will look at how we can use lists to do the following: Dynamic Filtering on a Column Using Lists Changing a Table of Attributes and Values to retain only Top 10 Attributes (by values) […]

Power BI incremental refresh is a very powerful feature and now it’s available in Shared capacity (not just Premium) everyone can use it. It’s designed for scenarios where you have a da…

Companies are generating an amazing amount of data, but do they know how to use it? Often, the answer is ‘not really.’ You need to leverage a solution that can help your employees understand what your data is telling them. With Microsoft Power BI, you have access to manipulate, learn from and act on your […]

The digital transformation has already begun. By 2020, 60% of all enterprises will have fully articulated an organisation- wide digital platform strategy. Where will your business be by 2020? Don’t fall behind. Bring your enterprise up to speed with Microsoft Azure. Contact us to learn more on how we can help you adopt this transformative […]

There are three main points of advantages in using aggregations (what we can get from the official documentation): Better query performance over big dataOptimized data refreshBalanced architectures…

This article describes how to use conditional formatting with a DAX expression to color the rows of a table in Power BI based on the order number instead of

Learn about using mapbox inside power bi with this excellent free tutorial from Alice Drummond. This tutorial is a quick getting started example.

We’re excited to announce this capability is generally available (GA). Now, we’ve improved the experiences based on customer feedback to help authors and consumers get the best possible app experience.  Learn about it in this blog.

I recently on some internal email by the developers where they mentioned something, offhand, what I think is amazing :). It will allow you to add measures by copy and...

I was playing around with calculation groups for a question. I found that adding a calculation group is not that straightforward as it should be, so I decided to blog...

One of the cool things of calculation groups is they cannot just be used to apply a calculation over your “base measure” but also apply a dynamic formatstring. You could...

Recently, I was asked by my supervisors to hide the column header ‘Over/Under’. There are a few ways to solve this, and I will show you my approach. Below is my table before and after. Steps We want the name of the ‘Over/Under Field’ to be blank. If you try to erase the verbiage on […]

This is a blog post series to show various ways of creating parts of landing pages for better UX and navigation Tiles using, Images, Power BI buttons, hover effects and all the above…

Sometimes in the grind of data wrangling, slinging some DAX code, and laying down some sweet charts, graphs, and tables, we can forget that the softer “non-data stuff” can really drive usability and adoption. It’s very easy for us (the report authors) to underestimate how much better we understand our reports than our users do. We just implicitly “get” the meaning of each metric, and are aware of each interactive capability. It’s important for us authors to try to step outside our own knowledge and history in order to see things from the naïve user perspective. A good data visualization is ...

Today our great friend Alex Powers is walking us through how to use the Open Broadcaster Software OBS to increase our brand via video streams. Alex is a Micr...

Navigating organizational change through Power BI in the turbulent landscape of 2020.

Do you want to learn how to contain your ETL within Power BI? In a recent webinar with Consultant Nick Lee you’ll learn some tips and tricks when it comes to setting up your ETL pro…

In this blogpost I’m going to talk about how to design an effective Power BI report. While report designing is a highly subjective area, I will try to make it more generalize as much as possi…

This is the second post of a series covering best practice guide for Power BI users. If you have not read the previous post, you can check using below link. In this post, I’m mainly focusing on nam…

I have seen so many people have different ways of using Power BI as an analytic and reporting tool. They all have their own way of designing dashboards/reports, naming objects, create calculations,…

Govern for maximum impact. Agility balanced with structure.