Power BI

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 […]

A responsive app resizes the app based on the browser window and moves parts of the app to make the app work in different screen sizes. The most common sizes to handle are monitor, tablet and mobile phone. Create the App In the video and for my example I design the app based on a the larger size and then...

Before you start a responsive app you need to plan where each element will be on the screen at the different screen sizes. Planning is vital.

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.

ALM Toolkit is one of those must have tools for PowerBI. Learn about this tool from Christian Wade and how the ALM Toolkit aids your Power BI Development.

Today, I’m excited to introduce the lineage view GA and new advanced experiences within the lineage view. Check it out!

To encourage the use of standardized dataflows, Power BI now provides two ways you can increase the visibility of your valuable, high-quality dataflows: promotion and certification.

This is a documentation of hidden but essential microsoft power query keyboard shortcuts, for power bi, that is meant to make operations less tedious.

Time series forecasting in PowerBI. (An Almost) Comprehensive Guide