Power BI

I've been searching over and over, but I can't find the solution - so I'm afraid that there isn't any solution to this. I have a table ("Time reports") with all reporting for our employes, grouped by Person and Date. The table looks like this example:   Date Person Billed hours 2017-04-12 Joe 5 201...

As of today, all Microsoft Power BI users can start using dynamic and cool-looking ZoomCharts in reports and dashboards. With ZoomCharts, you can easier than ever before, explore, present and analyze your data. Full multi-touch support makes interaction seamless across all your devices. See it for yourself and learn more!

I am unable to change the format of a measure. The Formatting section of the Modeling tab only allows Format: Text to be selected. Here's the measure: NHSSVUNNetAssets = CALCULATE(MEDIAN(AuditNumbers[UnrestNA]),AuditNumbers[PCODE]="8217")   It's possible I am using the wrong DAX. For example, Media...

I am making a sales etimates report and I'm stuck at the problem of using the deal information to create the table of future invoices.   I have a table of Deals with following fields: period_start = DATE period_end = DATE schedule = one of ("once", "monthly", "quarterly") Now I need to create the t...

The Challenge A fairly common data model design pattern can be described such that: Given a set of criteria that are numerically scored These scored criteria are grouped together in arbitrary sets and the group scored via an aggregation of criteria scores These groups of scores are further grouped ...

I knew that the performance of M in the query editor of PowerBI was much better than in Excel, but only today I discovered the incredible difference we actually have (…) Read more

Hi!   I've been spending my day banging head to the wall with this problem. I need to check if value is a duplicate of value in the same column that is filtered by slicer.   Slicer Part code Has duplicates 1 14 FALSE 1 15 FALSE 1 16 FALSE 2 14 TRUE 2 15 FALSE 2 16 FALSE 2 14 TRUE     I was going for...

I got really stumped for my whole day on how to display marketshare on Power BI. My data is kind of complicated but I will try to simplify the problem in here, assume I have two tables:   1. Dimension Supplier:     2. FactInvoice:     I would like to display the marketshare (Sum of Spend) for one ...

As part of the Microsoft Build event, we are announcing a developer preview of the Data Connector SDK. You can begin to create your own custom data connectors. What are data connectors? Simply put, they are how you connect to data within Power BI. These are extensions on the connectivity/Mashup engine that powers the “Get Data” experience in Power BI and Excel.

If you use Power BI to connect to a data source such as SQL Server in DirectQuery mode, you’ll find that by default you cannot use the complete range of DAX functions inside your calculations. For …

Amid all the other announcements at Microsoft Build today came one I’ve been waiting for a long time: we can now build our own custom data connectors for Power BI. Here’s the announcement on the Po…

The Microsoft Data Insights Summit Data Analytics Challenge runs from May 8, 2017 to June 4, 2017.   Your entry should be emailed to community@microsoft.com, and must include:   1. The category in which you are entering (you may only enter once in each category) 2. A Power BI Desktop file (under 50 ...

Visualizes the change in team standings between 2015 and 2016 for Major League Baseball's American League Central division. This visualization showcases the use of the sigmoid function to create curves. More detail in my blog post here: https://dataveld.wordpress.com/2017/05/06/throwing-a-curve-at-t...

Greetings,   I was wondering if there was a way to display the most common value in a column? For example:   Reported_Users UserA UserB UserC UserA UserA UserA   Here UserA is the most common user. So I was thinking of trying to display it with a  "Card" visual.   I think I read somewhere it's possi...

Hi   How can I represent the following using DAX. I am trying to Bucket the following Sales Quantity per Customer:   Customer Quantity A 0 A 200 A 300 B 100 C 80 C 20 D 50 D 25 D 25 D 0 TOTAL 800   and represent the following in Buckets of 3 as Top 20%, Mid 60% and Bottom 20% of the Total as below: ...

Hi,   I need to create a report that will show me realised values and estimated values for the rest of the year.   The report should be a table having finance accounts on rows and months in the columns. If the user filter the year to 2017 and month to april the first 4 columns should show realised v...

Announced today are some really cool new Power BI features: Power BI Premium Previously available were two tiers, Power BI Free and Power BI Pro ($10/user/month).  The problem with Power BI Pro is …

As Buck Woody notes here, when you are exploring a new data set it can be useful calculate some basic descriptive statistics. One new M function that appeared in Power BI recently can help you to d…

With Power BI apps, now in preview, you can easily deploy and manage a collection of purpose-built dashboards and reports to a large number of business users and empower them to make data-driven decisions. You can distribute them to the whole organization or to specific people or groups.

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.