Power BI

Yesterday I found out we have a great feature in Power BI that everyone should know about but I stumbled upon by accident. it turns out you can create your own, fully customized, usage reports to s…

We are excited to announce support for ‘bring your own entities’ for the Bing News solution template! The Bing News template allows brand managers to find articles most relevant to them by filtering on sentiment, trending topics as well as entities like locations, organizations and people. One of the most common feature requests we received was the ability to define your own list of words and use that to slice your data. A product manager may want to e.g. create a list of products or company names and use that to slice and dice collected news articles. Read on to find out how you can incorp...

There is a video that walks you through the solution in depth, please find the video at the end of this post along with the completed solution. In this installment of the Problem, Design, So…

Hello MS-BI Community,   I am new here and I want to ask for help with following issue.   I have a contract table about periodic monthy or yearly payments. contractno date enddate formula amount 1 01.01.2016 01.12.2016 1m 35 2 01.02.2016   1m 453,54 3 01.03.2016   1j 45,23 4 01.04.2016 01.06.2016 1m...

I have been working with DAX for quite some time now, and I've come across a rather complex Percent of Total Revenue request.  I'm thinking DAX should be able to accomplish this fairly easily as Pivot Table calculated fileds makes it easy enough.  First off, to calculate Percent of Total Revenue for...

Hello, everybody!   I'd like to know if is possible to do a bar chart in Power BI like the image below.     I have a bar whose data is the cumulative of the year 2016 and then I have others bars whose data are the sum of each month of 2017.  Is there anyway to freeze the first bar (2016) on the bar...

I was giving my Row Level Security session last weekend for the Richmond User Group ( @RichmondSQL   http://rva.pass.org/) and a question came up (ok, so I technically asked the question). How does the feature work with indexed views? Generally speaking,

Hello, I'm trying to get 30 day moving avg measure to work without having to first create a summarized table (count, group by date) of source data.      Measure that works with summarized table 30 Day Moving Avg = CALCULATE( AVERAGEX ('Summary Table (Case Count)', 'Summary Table (Case Count)'[Counto...

Predictive Analytics – Budgeting About 1 out of every 5 customers we talk with nowadays is interested in using their data to predict the future and from our perspective, 5 out of 5 customers we talk to have the opportunity to do so. So what is Predictive Analytics ? It is simply visualizing the future based […]

Hi,   I'm trying to create a measure to be used as a tooltip in a treemap. The tooltip should show a list of the top 5 sub-items with a total.   For example, each tree item in the chart is a state. The tooltip should show the 5 top cities in the state and the total value for each city.    I'm able t...

I have a table with a population of people and a value per person. I need to build a single measure to calculate the average value by tier. The tiers should be defined by % of people sorted by value, e.g. 60% bottom, next 20% and top 20%.   Usage of a parameter table to easily adapt the numbers and ...

the

Hello,   I am currently working with a data set to produce cumulative counts (which I have working perfectly) however I have a problem with my next step.   The data should all at some point go through "Stage 1" however due to various reasons it doesn't always happen.   My data looks like this:   ID ...

Hello,   I'm new to Power BI and I'm stuck with a problem. I have a table with calls including the fields customer, start_date and end_date No I want to see how many call are active during a given period (line chart or similar over the period would be good) e.g. Customer Start_Date End_Date A 27.06....

This is the data I have: (Grouped by Lot and Site) Table1: Lot_PK Device Lot Site Total Parts-Phase1 Passed Parts-Phase1 Yield-Phase1 Total Parts-Phase2 Passed Parts-Phase2 Yield-Phase2 1 D1 L1 1 100 80 80 20 15 75 1 D1 L1 2 100 70 70 30 20 66.67 2 D1 L2 1 100 70 70 0 0 0 2 D1 L2 2 100 85 85 45 35 7...

The autoexist logic magically removes combinations that don’t exist, but only for columns in the same table.  Also, Cross Table Filtering...

Who doesn't love KPI icons in tables?  They provide instant feedback on performance metrics, alerting us to a job well done or for the need of further action.  Either way, they help us to better manage our portfolio.   One of the most powerful aspects of MS Power BI Desktop, the DAX formula language...

In this module you will learn how to use the Quadrant Chart Custom Visual.  The Quadrant Chart is used to show a distribution of data across separate quadrants. Module 63 – Quadrant Chart Downloads…

Got a good question this week that had me scratching my head for a bit but then I remembered a new function that was added to Power BI (and SSAS) recently called TreatAS. Marco covered it in detail…

A few weeks ago I was asked whether it was possible to display line breaks in text in a Power BI visualisation. It turns out it isn’t possible – at the moment Power BI always strips line breaks out…

I was helping out in the Power BI Community and I came across the following requirement. The user had sales figures and based on the Previous month, they wanted to have an arrow showing if it was up or down. As well as if there was no data to say that there was no data. So this is how I achieved thi...

Last week I had the chance to do something I have not done before: build a Power BI report to be displayed on a big screen hanging on a wall. To make up for the loss of user interactivity, I used t…

How To: Import SharePoint libraries into Power BI and create links to the documents If you have tried to import from SharePoint to power BI you have probably

Forecasting is when we anticipate the behavior of lots of people on long timelines. Predictive Analytics anticipate the behavior of One person...

Normalize numeric data from several independent ranges to a uniform scale ranging from 0 to 1. This can be used as a precursor for clustering, creating parallel coordinates plots, and more.   Follows formula: (x-min(x))/(max(x)-min(x)) Using the DAX measure:   Normalized Value = VAR MinOfGroup = CA...

Hi Everyone,   So I have a following Data Set:   Revenue CustomerKey 10 1 20 2 30 3 25 4 45 4 60 5 100 3   What I am struggling with is getting how many customers bring 50, 30 and 20% of Revenue respectively.   I am trying to get:  % Revenue Customers 50% X 30% Y 20% Z   You help would be much appre...

Hi,   I've got some Google Searchconsole Data and I want to create a tile that compares the Average Position on a certain date, which is chosen by a slicer, with the Average Position one week earlier. The following just gives me a "(Blank)":   AveragePositionOneWeekEarlier = CALCULATE ( [AveragePosi...

A B C D E 1 A o 1 0.8 2 A o 212 0.5 3 A o 23 0.2 4 A o 45 1 5 B o 343 0.3 6 B o 32 0.4 7 B o 234 0.5 8 B o 213 0.6 9 C v 65 0.7 10 C v 678 0.8 11 C v 564 0.6 12 A v 23 0.6 13 A v 12 0.6 14 A v 32 0.6 15 A v 11 0.6 16 E v 22 0.6   I have the above table ... I wanted to calculate the weighted avarage ...