Supporto di Power BI

Cerca

Re: Average employees rolling 3 months

try this code - it uses TOPN to get last 3 months, ADDCOLUMN to add [Headcount] and finally AVERAGEX to calculate the average on the output Average 3 month = VAR CurrentPeriod = MAX ( Cal...

Dax Query ( Sum of Max )

Hello everybody, I'm looking for a DAX measure that calculates this :   Person    Sales 1            10$ 1            1...

Re: BUG: NATURALLEFTOUTERJOIN can't be used to create calculated table

I'm just getting started in Power BI and came across this issue today when trying to merge the results of a SQL direct query and an Excel file. Initially I couldn't find the merge button (in Power BI...

Re: Power BI visualization issue

How do I chart the values for defects without any count or sum?

Re: Enterprise Gateway security settings - Admin VS User

The other user was in a different (older) version of Power BI Desktop. Updated to the oktober release and now it works.

Re: link to a word document

Do you have another sollution? let's say i do print screens and import as images and put as tool tip of a button or text ; can i? thanks Cosmin

Re: Report Server portal loading extremely slow

Hello. We have the same issue. The solution still cannot be found.

Re: Moving Reports on Dashboard

Problem resolved. While in the reports view, instead of clicking on the 'Pin Live Page' at the top of the page, click on the 'pin' on an item you wish to add to your Dashboard and Create New. T...

Re: Extracting dates from date ranges

Hi @Zubair_Muhammad, That worked really well! Thanks!

Time Intelligence and R in Power BI

Hello to everyone, I'm new in PowerBI and I need to give an answer to my boss by the end of the day. Could you please help me? Right know I have a Dashboard that needs 4 hours to run, it has 100+ me...

Re: Unable to Republish the app

@ankku, Do you mean that the users are unable to update app in Power BI Service? If so, what error message do the users get? What specific changes do they make? I am unable to reproduce ...

Re: Line Chart: Conditional Formatting

hi,   i am new to Dax and power BI.   can share with me how this work? where do you enter the DAX code to make the two line appeared in the visual chart?    how can we creat...

Unable to connect to Application Insights

When trying to conenct to Applciation Insights, I'm constantly seeing an error:   Failed to update data source credentials: The credentials provided for the ApplicationInsights source are in...

Re: How to create calculate spells ?

Hi @v-jiascu-msft   I am sorry, you are right.  I have forgotten send you the other column with the formula (I've renamed this column as "FinalIndex")   List.Accumulate(l...

Looking for a way to return the first value based on two sorting functions

Hi guys,     I have a table which party looks as follows:   Customer,    Order#,    OrderDate,    SalesChannel   We can have multiple customer...

Trying to use slicer on top of a group, it's not working

I've created a "New group" to group together a text field. Now when I put two slicers on the report, one holding my group and another holdings original field, the two of them do not work together cor...

Missing data

I started a trial of Power BI last week to see if it would be a good fit for our customers.  I had added some datasets, reports, gateways and had created an app out of some of the datasets and r...

Sort By Column: Not Open Up

I'm having an issue with "Sort by Column" The button is visible and clickable But when clicked, it wouldn't open up the list of columns to select!  Does anyone else have this issue?   ...

Count based on a columns particular value and this count should ignore any available filters

Hi,   I need to create a measure, which calcualtes the total count based on a particualr columns value. I know how to do this. However, when I use this meaure, I dont want its value to ch...

Re: Count based on a columns particular value and this count should ignore any available filters

I think I didn't try enough before posting this. I managed to figure this out using the below : Number of Open Requests =  COUNTROWS(FILTER(ALL('Report requests'), 'Report requests'[Status]="O...

Re: countrows with conditions in other column

Something like this Measure = calculate(countrows(Table);Table[Model]="New")

Re: Calculate different figures in Matrix based on displayed hierarchy level using DAX

Hi, This is working only if You have fix hierarchy and each level are fulfilled but I dont have fix hierarchy and some companies going up to level 6 and some only to level 4. Think I find solution ...

Re: Sept 2018 Release - Manage Aggregations - Cannot Sum Decimal Number

Hi @tctrout,   I'm not very clear about the issue you mean. Please record a video to clarify it.    Best Regards, Qiuyun Yu 

Re: Version Control Using SharePoint-Error while opening .pbix in Power BI Desktop from File Explore

Hi @BBIUser, I have asked the Product Group for more details, I will post the information once I get any updates. And I suggest you could just download the pbix file manually from SharePoint S...