Power BI

I'm looking to add an index column, but have it increase according to a certain column value. Let me give an example; let's say my data is: Group      Date A 18-Apr A 19-Apr A 23-Apr A 1-May B 21-Apr B 21-Apr B 30-Apr B 4-May   And I would like to have the indices show like this: Group        Date  ...

This was a problem that took me a little bit longer to solve than I expected. We’ve developed a business intelligence solution for a training...

This month has many updates to previously released features, including an upgrade to tables to add the great features our new matrix, two new quick measures, and a new way to create bins. You’ll also now be able to take advantage of a new slicer type that lets you filter your reports down to relative dates, such as last 3 months. We are also very excited to announce report level measures for live connections to Analysis Services tabular models & Power BI service datasets.

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…