Поддержка Power BI

Return value from a different table

Hi everyone,   Am running into difficulties when I try to dice information. Below is the Relationship between my tables. I want to create a column where it looks at the Subaccount Name in the ...

Re: data collected at different time interval but shown as if at same time interval

Yes. Or at least the points above are distanced proportionally to the time they are collected (should of be equally distanced since they are collected at different time intervals)

Re: dax max of not working

Hi @jtmize, What's the data type and format of  [MonYr] and [PE FC MoYr]? MAX function is only used to number values, which evaluates a single column that contains numeric...

Re: Rename columns based on data in another table

@andy_vdg,   Based on my test, you may refer to the following code. #"Renamed Columns" = Table.RenameColumns(Source , Table.ToRows(Table.Sel...

Re: Google Analytics custom segments and custom reports

I am also looking to the answer of this problem.   Is it possible to import custom build dimensions from Google Analytics to Power BI?    Cheers! 

Importing custom font in power BI desktop

Hi, I would like to use a new cutom font (Proxima Nova) for both custom visual type and default visual type in power BI desktop. So how can i add new custom fonts in power BI desktop. Can...

Re: Dataset won't refresh from Azure SQL

I figured it out. For some reason the new credentials didn't pass over from Desktop to Service.

retrieve text/string from cells in excel

Hi everyone,   Thanks for your attention. I would like to retrieve several information to made counts of a certain information as for ETL. My question is that how can I write the DAX script to...

Count Statuses - DAX Help!!!!

I am currently using an "IF" function to apply a value of "Applied" or "N/A" within a column of a table.   I am looking for some help in a DAX statement that will allow me to do the following:...

Scatter Chart: custom visual question

Hello,    The Scatter Chart within Power BI has a nice feature where, if you add a slicer to your chart, each time you select a slicer option the bubble markers will "slide" around the gr...

Re: Retrieve latest date

HI @jaafer,   Nope, it not in query editor, it is dax formula.   You can navigate to modify tab and choose new table, then input these to formula panel.   Regar...

Re: Query Editor Window Bug

Hi @jameslo30,   I review the video and I see before 00:16 you are just clicking on the query not hold it so the query doesn't move. After that time you are clicking on the qu...

Extend block of values

Hi guys,   This is a quick question that I have.   I have a table that looks like:   Type        Country       Date&nb...

Re: Rolling totals

Hi @lmundia,   Could you post your table structures with just some sample/mock data, and the expected result against the data? So that it will be easier for us to do some tests on it, t...

Some API functions don't work using TypeScipt

Hello   I am trying to embed report using TypeScript: import * as pbi from 'powerbi-client'; let powerbi = new pbi.service.Service(pbi.factories.hpmFactory, pbi.factories.wpmpFactory, pbi.fa...

Re: Power BI dataset refresh is failing without details - works fine using Desktop - Status changed to: Needs Info

Power BI EM SKUS work with Live Connection/ Direct Query ?

I have searched far and wide for an answer on implementing data on Power BI and hope someone can help.   Do the Power BI EM SKUS (EM1-EM3) support Live Connection / Direct Query data connectio...

don't have any gateway installed or configured

Hello,   After creation and publishing of the new report faced with trouble of scheduled data refresh configuration:   You don't have any gateway installed or configured for the data so...

Re: Pareto Chart with multiple aggregation levels

Hi Angelina @v-huizhn-msft, I just noticed that the cumulated amount of deliveries is not correct if I remove the filters or select on monthly level. Only when the filters are set on a specific ...

Re: Gantt automatically count %completion?

@cbouichi, You would need to drag Druu.1 field to Duration of Gantt chart, please review the following screenshots. Regards, Lydia

Annual Returns

I am trying to calculate a fund's yearly performance based on monthly returns. In excel we calculate the yearly performance with the formula B12/B2-1 which gives us the total performance for 201...

Re: Power BI Service is down

Yes, we're having the same issue in Australia in Brisbane

Re: BUG: KPI depends on order of steps taken to build the visual

@ToddChitt   I’ve got response from the Product Team.   The fix should be available next month.   Best Regards, Herbert

RANKX Issue!

Hi!   I have an strange rankx issue. I used to use RANKX measure currently in other work Im doing, but now in this file all RANK im trying to do does not have the expected result. It is very s...

Re: Add an extra field from a data source

Sorry, Pand.   the solution I described was the only one i was able to figure out.  Let me know if you find another way.