Power BI

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 ...

Hi,   I'm trying to figure out how to idenitfy new merchants based off transaction data. I have a transaction table that has merchant info included. The firstdate function looks like it has worked when I create a table of merchant ID and first transaction date. But I'm not sure how to sum the new me...

Okay, here is a head scratcher for you all. I have a table in Power BI which list contract dates. So it will have columns such as below..   Product     StartDate    EndDate     LOS Product1    20/11/17      30/11/17    11 Product2    02/01/16      19/03/16    78   I need to work out how long a produ...

Hi,   I'm hoping to use PowerBI to show overall market trends as well as trends in individual accounts. My data has several different slicers, e.g. location, device type, etc.   Is is possible for me to show two lines on a line graph, one for the overall marketplace average, and one for the individu...

Hi guys,   Would appreciate some's help with this;   I have a SALE Table and a Calendar Table with Financial Years ending June. I would like tp categorise clients in the Sales table as "New" or "Exisitng". If a client was invoices in the previous financial year then its flagged as "Exisiting". If a ...

Hi All,   I'm new to BI, and would really appreciate your input on what would be the next steps to take for a report I'm working on. Currently, I've a list of projects (PO's), with several criteria that need to be met before they are completed. Once all criteria are met, the PO in general is complet...

I have been using disconnected slicers for quite some time. What I love about them is that you can use them so that a user does not have to go to individual pages to view different measures or valu…

For the past few years I’ve combined my love of professional football and analytics by releasing a series of Power BI reports featuring player statistics. This year is no different. This year I’m f…

Drill through reporting using Power BI

Recently I’ve been building a lot of Power BI reports from csv and Excel files, and to make sure that scheduled refresh works I have been setting up data sources in an On Premises Data Gateway (wha…

Over the past few weeks I’ve spent some time playing around with Power BI custom data connectors and while I don’t have anything to share publicly yet (other people are way ahead of me in this resp…

In this module you will learn how to use the Power KPI Custom Visual.  The Power KPI displays your KPI indicator values on a helpful multi-line chart with labels. Module 61 – Power KPI Downloads Po…

Early adoption of new custom visuals in Power BI is a great way to explore new insights, or to impress your colleagues, boss or clients, and captivate your report consumers. So, when you want to explore the latest custom visuals that were released in Office Store, or from Power BI Desktop (As seen in the …

by Avichal Singh Now that Rob has acquainted us all with the Power BI family, I wanted to take a closer look at one of the relatively new members: Natural

rDataTable - R custom visual for Microsoft Power BI based on DT / DataTables

I haven't been able to get the Filtered URL feature on my dashboard to work. I believe I followed all the steps. While the column to be filtered on (PartID) contained numbers, I changed it into a Text format.   I published this report, made a dashboard of the page I want and tried to access that das...

Hi folks,   I have a table of unregular day cash in and outflows for a few years. How do I create a measure for waterfall chart that begins with previous month balance, then showing increases/decreases for every day of the filtered month, ending with the balance at the end of the filtered month? My ...

Hello,   Iam looking for a solution for following problem: Given table below:   Date Hour Reach more more more 16.06.2017 4 125 x x x 16.06.2017 5 85 x x x 16.06.2017 6 45 x x x 16.06.2017 7 189 x x x 17.06.2017 7 450 x x x 17.06.2017 8 384 x x x 19.06.2017 7 142 x x x 19.06.2017 8 12 x x x 19.06.20...

Update: 16 December 2016 (I got a comment from Marco Russo, who suggested that can use the FILTERS DAX Syntax which will “Return a table of the filter values applied directly to the specified…

Where I am currently consulting there was a requirement to create a measure like you can in the Excel pivot tables for the % of Column Total or the % of Row Total. One of the things that you can cu…

Recently one of my business users came to me asking “how can I get a Clickable Card in Power BI”? He wants a card where he can show the measured…