Power BI

How can I use the Power BI Q and A? What are some helpful tips for using it? Are there any limitations? What sort of visualizations are available? Can I pin the visualizations to dashboards?

Learn how to create a bell curve and histogram with the Power BI Desktop.

As I remember managers used to love SSRS reports for their availability of traffic light indicators which are useful way of measuring KPIs, trends etc. During my recent Power BI engagements with clients I have been asked few times if similar can be achieved in Power BI and my answer to that was, y...

Power BI Natural Language Q&A looks great in demos; mind blowing in fact. Just type in any question and get your answer right away! Can’t get any bette

Hello community,   I have a question related to the frequency golf players are linked to each other during a competition. Imagine players are grouped together in several flights during one day, and grouped together differently in flights the next day. This continuous during the season. Now I want to...

May and June Webinars: Power BI Security, Best Practices from the Microsoft Operations Team, Power BI Embedded, Marco Russo on Design and more!

Hi,   I want to create a dax formula that will produce a list of unique guest values from Column A, and find only the distinct value in column B (Host) based on the latest date.  The final report will only have a list of distinct guests and one host per guest.  Although, I would expect to see multip...

When designing your reports in Power BI Desktop you properly spent a lot of time making sure your visualizations is aligned and at least for some of them making sure they have the same size. So far…

The techniques used here are seriously awesome. The opportunities are really unlimited once you understand the steps required to make this happen.   To confirm what I mean by making visuals dynamic, in this example what we want to be able to do is dynamically view information over different time per...

Is it possible to dynamically calculate ranks based on filters? If I filter B, D, E can I see the new ranks as 1, 2, 3?

Hi Everybody   How can I write a DAX expression that show only the Sales of the last 5 five years based on the current selection of the year. For Example: -If I select 2015, the chart should show only sales for the years 2015, 2014, 2013, 2012, 2011 -If I select 2012, the chart should show only sale...

Hi all.   I am new in this community, and very dummy in Power Bi. I have a fact table with a link to a master calendar by the date. The problem I have is this: I have created a mesure this way:   Valor Euros = SUMX(FILTER( 'Hechos Hstock_valorado' ;  RELATED(Tiempo[Fecha]) = max(Tiempo[Fecha]));'Hec...

Hello,   I want to calculate the following: the average for the last 3 months and i want to project this data for the rest of the year.   For example: the data for the first 3 months is real data   jan    feb   mar     apr     may     jun    jul 10      20    30        20      20       20     20   I...

Hi, I need to represent a report that shows weekly trend of YTD average of a sales per region. Any advise on how can I use Power BI to help me? This is the example   Region    Day    Sales Amount A             1         1000 A             2         1500 A             3         700 B             1   ...

Sample data: https://www.dropbox.com/sh/lzgqonrufze6mql/AABDGjIHOvu7iraqXeqKTmA9a?dl=0   We have a "PromiseDate" which is when we tell the customer it will be ready. The product needs to be passed quality control (DatePassedQC) at least one work day prior to the PromiseDate. If the DatePassedQC is o...

In this module you will learn how to use the Table Sorter Power BI Custom Visual.  The Table Sorter allows you to rapidly re-sort and rank values by within a table. Module 46 – Table Sorter Downloa…

This article describes a number of techniques available to filter tables in DAX, showing possible pitfalls that you can avoid once you know them, in particu

A common approach to assess ROI on any BI tool deployment is through adoption metrics. Check out this example to see how you can track your adoption rates!

Power BI Desktop – Terms and Definitions The following list of Power BI Desktop terms and definitions are intended to help users better understand the terminology used within the product and referenced in documentation and blogs. As I work on customer sites to teach, develop, and evangelize Power BI, I’ve been asked often for a...

I knew that the create Column From Examples feature had been released to Power BI Desktop, but it just showed up in my Excel 2016 build today.  And man is it cool! A scenario for Create Column From Examples A … Continue reading →

Quick measures, a new feature we released in our April Power BI Desktop update, lets you quickly create new measures based on measures and numerical columns in your table. These new measures become…

Spent some time experimenting with the excellent “Synoptic Panel by OKViz” custom visualisation and came up with the idea of finding a different way to visualise the costs associated with a companies organisation structure. Organisation Chart & Associated Salaries and Costs Report  Image 1: Report showing Total Salaries and Costs for a fictitious organisation.  The Organisation Chart diagram in … Continue reading "Power BI – Visualisation – Org Chart"

Traditionally, when we do variance analysis, we compare the actual value of the metric being measured to its target value in either absolute or relative terms. For example, if I were to compare cur…

Microsoft's 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…