rss.livelink.threads-in-node

Source code for PowerBI native table visual

v-mubish — Thu, 08 Jun 2017 07:57:38 GMT

Hi all,

Can anybody provide the source code for native/inbuilt table visual of powerBI?

Any references/suggestions are appreciated.

Thanks,

Mukul

Power Pivot, Power View and Power BI ?

JonathanJohns — Thu, 08 Jun 2017 07:54:17 GMT

Good morning everyone,

I have a question about two extensions in Excel which look like Power BI. Can you explain me why Power BI is better than Power View and Power Pivot please ? I don't use these applications but I don't know what is the difference between them.

Thank you for your advice.

Dynamic filter not working

dan_yoxall — Thu, 08 Jun 2017 07:43:42 GMT

With the below is an snapshot of the first few of lines of data I am trying to create a line graph of [Cost. Reg] against [Date] but filter the date by [Origin] and [Task].

I used the below measure and it worked fine (see graph further below). However I want the [Task] filter to be dynamic. If I create a slide using the [Task] field and omit the text in bold the filter doesn't appear to work. Any idea why?

Cumulative Spend to Date (Time Sheet) =
CALCULATE(
SUMX ( 'Project Hours Booked', 'Project Hours Booked'[Cost, Reg.]) * MAX('Fee Factor'[Fee Factor]),
FILTER(
ALL('Project Hours Booked'),
'Project Hours Booked'[Date] <= MAX('Project Hours Booked'[Date]) &&
'Project Hours Booked'[Origin] = "TIME SHEET" &&
OR('Project Hours Booked'[Task] = "1000", OR('Project Hours Booked'[Task] = "1100", 'Project Hours Booked'[Task] = "1200"))
)
)

Selective report sharing within an organization

rode — Thu, 08 Jun 2017 07:39:29 GMT

Hi everyone,

I'm working on a report within an organization.

This report is composed by four sections: each of them must be used by a specific target of people of this organization. Anyway, the dataset and the measures are the same for each section, so there is a unique report.

What are your suggestions regarding the sharing?

- If I create four different dashboards I should divide the master report into four different report, each one for a section (in order to deny to the users to access to other sections)

- I think that the same will be If I share with four different groups

- Could the right option be the content pack opportunity?

Thanks in advance,

Regards.

[BUG] Bar chart: show values with no data

rode — Thu, 08 Jun 2017 07:30:16 GMT

Hi everyone,

I have the last release of Power BI Desktop. On a report I am working on I have a problem with bar charts.

On the x axes there are four countries, on the y axes there are some KPIs. Also if I select the option "show values with no data" on the x axes configuration, the chart shows only less countries when I filter something.

But if I create a new bar chart with the same configuration of the previous one the problem is solved. It seems to be a bug.

I ask to Microsoft to figure out what's the problem inside this situation.

Thank you,

Regards.

When does a dashboard refresh?

binesh2003 — Thu, 08 Jun 2017 07:20:48 GMT

I created 2 kinds of reports,

one is directly created on PowerBI portal using excel file stored in SharePoint, so no pbix file. (here)
2nd is created by query using Power BI Desktop, can have pbix file. (here)

The problem is, I’d like to input the Compass page link within hyperlink, (then APAC stakeholder can easily track the all information). But to input the hyperlink, have to use Powerbi Desktop application, it cannot be done by PowerBi Portal.

That’s why I made 2nd dashboard, but the problem is here, syncing does not work automatically in short time. It should have to wait at least 1 hour or manually click the “refresh” button in PowerBI Desktop application.

Percent Complete by Cohort in different table

rayinOz — Thu, 08 Jun 2017 07:04:52 GMT

Hello,

I'm having trouble coming up with a percent of a total that is in a different table.

I have two tables "main" which is a list of course enrolments. and I have "users" which is a list of all users in our system.

I have the following measures in my "main" table:

Total Enrol = CALCULATE(COUNT(Main[Course Name]))

Total Cohort = CALCULATE(COUNT('trainme-users'[profile_field_employeenumber]),FILTER('trainme-users', 'trainme-users'[profile_field_assignmentgroup]="Casual / Honorary"))

Percent Enrolled = [Total Enrol]/[Total Cohort]

When I put the measures into a visualisation card, the numbers (totals) show correctly. Its when I put the Percent Enrolled measure as a value in the bar chart visualisation where things go wrong. Most of the chart is showing 100%.

Help! LOL.

Thanks for any help.

Rayinoz

Stacked Column Chart with two variables - I don't get it to work

Qbasic2002 — Thu, 08 Jun 2017 06:55:07 GMT

Hello Community,

I have a table with to categorial variables, Cat1 and Cat2. Both range from 1, 2, 3, .... to 10.

I would now like to show the distribution over all observations for both variables, cat1 and cat2, in one stacked clolumn chart.

I simply created a stacked column chart, where I dragged both variables in the value field (count). As axis, I tried several things: simply use one variable (cat1, cat2) or create a new table with a variable going from 1 to 10. Neither of this worked for me.

Any ideas?

Thanks

andreas

Wrong calculation of the total of a measure

Lisa_G — Thu, 08 Jun 2017 06:44:48 GMT

Hi,

I want to make a measure to calculate the cost saving per raw material (per every single material (e.g. K-9611-75-2) and in total) over 2 years). I make a daily update of the data. The point is, when we have materials that only have transaction in one year the cost saving comparison cannot be calculated. We had the idea not to consider these materials and made therefore the following if-function:

Data:

- In the table I have information’s of every delivery per product with e.g. material, delivery date, net value, quantity.

- The Order Price CY (CY = Current Year) is a calculated column (Net Value CY / Qty delivered CY).

- The Order Price LY (LY = Last Year) is a measure (Order Price CY; sameperiodlastyear()).

If the Order Price LY or the Order Price CY is 0 than the result for this respective material will be shown as 0. The problem of this way of calculation is that the total of the calculation doesn’t work.

Thank you,

Lisa

Dax help needed for latest 8 weeks total

JacobLI — Thu, 08 Jun 2017 06:15:46 GMT

Hi Everyone, I'm really new to DAX and have been struggling to come up with a solution to sum up latest 8 weeks data for each row. I've been trying filter function but it doesn't work.

I've simplified my ataset below, it has 3 columns:

Week ending date | 8 weeks ago date | count
10/03/2017 13/01/2017   0
17/03/2017 20/01/2017   1
24/03/2017 27/01/2017   1
31/03/2017 3/02/2017   0
7/04/2017    10/02/2017   1
14/04/2017 17/02/2017   0
21/04/2017 24/02/2017   0
28/04/2017 3/03/2017   0
5/05/2017 10/03/2017   1
12/05/2017 17/03/2017 0
19/05/2017 24/03/2017 1
26/05/2017 31/03/2017   0
2/06/2017 7/04/2017 1
9/06/2017 14/04/2017 1

What I want is to have a measure that can sum the count for last 8 weeks for each row.

i.e. for 9/06/2017 0:00 i should have get sum of counts from 21/04/2017 0:00 to 9/06/2017 0:00, which is 4. Kindly let me know if any functions or calculations that i could try out, thanks in advance!

PBI Embedded Premium - SSAS Multidimensional Direct Query Support?

andrel — Thu, 08 Jun 2017 06:01:13 GMT

Does anyone have information as to whether the new PBI Embedded - Premium SKUs will support DirectQuery access to SSAS MultiDimensional cubes or not, either via the On-Premises Gateway or via any other mechanism?

Thanks!

Tech Note:Exposing M Code and Query Metadata of Power BI (PBIX) File

Sunkari — Thu, 08 Jun 2017 05:56:13 GMT

Please find below for a nice article posted by Reza Rad.

Refer link:http://radacad.com/exposing-m-code-and-query-metadata-of-power-bi-pbix-file

https://gqbi.wordpress.com/2017/05/02/what-makes-up-a-power-bi-desktop-pbix-file/

Counting Rows based on certain conditions and grouping

mshamsiev — Thu, 08 Jun 2017 05:34:54 GMT

Hi all,

I'm trying to do a 'countifs' type calc.

Essentially I have a list of assignment groups with multiple appearances within one column, and an 'Achieved' or 'Breached' status (as seen below). I wan't to determine the % achieved by assignment groups. That way I can hopefully create a KPI visual that will filter based on the selected assignment group or across the firm without filters.

Any help will be much appreciated.

Example:

Assg Group Status

VC Achieved

CRM Breached

CRM Achieved

-Mike

Auto resize high of table base on data

hellgoingon — Thu, 08 Jun 2017 05:26:02 GMT

Hi all,

I have a table which get from Database. Number of rows in that tables will be changed from 1 to 100.

These data will be displayed in table control.

I want table will automatically be resized if number of rows in data.

Example: If data has 1 row, table will display 1 row. If data has 100 row, table will display 100 rows WITHOUT vertical scroll-bar.

How could i do that?

power bi embedded

ptrlv — Thu, 08 Jun 2017 05:11:11 GMT

Hi,

I'm trying to use power bi embedded but going through access issues.

I mananged to create the workspace and upload a sample report via powerbi-cli. I'm also generating the access token with 'powerbi create-embed-token'

The token seems to be valid. Below is the decoded version (from https://jwt.io/)

{
"ver": "0.2.0",
"aud": "https://analysis.windows.net/powerbi/api",
"iss": "Power BI Node SDK",
"type": "embed",
"wcn": "ProfilingOnline",
"wid": "0a29a0e2-5879-4be1-b11a-a1e16d0b7734",
"rid": "bc9204c4-52c3-40b0-b764-9cc54e2b16a7",
"nbf": 1496958040,
"exp": 1496961640
}

But when I test it on https://microsoft.github.io/PowerBI-JavaScript/demo/code-demo/index.html# I keep on getting not authorised.

Any ideas?

Thanks

Not able to figure out the formula for total in 'show totals' tab in Power BI/Power view table

Radhika — Thu, 08 Jun 2017 05:12:19 GMT

Hi,

I am facing the issue with total row in reports. I have a table and i have selected the option 'Show Totals' because of which i get Total below, not able to figure out the formula of total here in the below screenshot - if its an average of the values or anything else.

I appreciate quick help on this.

Dates in chronological order

pranim — Thu, 08 Jun 2017 05:06:18 GMT

How to arrange the dates on x - axis in Chronological order? I tried sorting by date, but its still not in order.

How to access PowerBI Reports hosted on-premise in web application

JameelM — Thu, 08 Jun 2017 04:48:53 GMT

I am having a PowerBI Report uploaded to Reporting Server using On-Premise. i want to access this report in my web application.

How to achieve this step by step?

Is it possible to access the report using "http://<ServerName>/<Report Path>" url format?

Customer vs Market Visual

lordtopcat — Thu, 08 Jun 2017 02:38:49 GMT

Hi there,

I'm building a visual that will provide results per customer. What I'd like to do is then compare those results to how the rest of the market is doing.

Each transaction in my data has customer and market, so the data is there... but I can't figure out how to display the data side by side in Power BI - if I can at all?

Appreciate any help!

Cheers

p.s The data is coming from a multi-dimensional cube so I can't alter the dataset within Power BI.

Dynamic Charts

shaheenmomin — Thu, 08 Jun 2017 02:21:32 GMT

Is it possible to change data with in a chart based on slicer value selection. For example below we can change the percentage for each period and this will be shown in the chart. so dynamically changing graph/chart based on user selection. Need this in Power BI.

Really appreciate all your help in advance..