Power BI 支持

搜索

Re: Show only data from the latest date

Hi @ChristianTD,   Seems date type values don't have a "TOP" filter type. I would suggest you try the measure below and add it to the "Visual Level filter". Don't need to add it to any ...

Re: Create Index Average - Divide row value by total of column

Is it possible for you to attach the datafile for your created visual?

Hierarchies in tables

Hello everyone, I have a problem with a table (Matrix) in Power BI. This table has several hierarchies with 2 rows and 2 columns for filtering, but I do not want the combo "Get details" Rows / ...

Re: Source Data Columns Expanding

I appreciate you running the test.  I ran a test as well, but received different results and it's possible it's because of my data settings.  For some reason the table only refreshes with t...

Re: Greyed out elements in online power bi app

Hey, thanks.  However, I'm not sure you're understanding the issue I'm actually having.  I'm not having an issue sharing reports or embedding to SharePoint at all.  The issue is that t...

Re: Measure that averages District Office and Total Company sales per week

Sorry, I made a mistake: the District Office measure WOULD follow the slicer (if "New York" is selected the measure would then return sales averages for the New York office).  

Re: DAX - Can a Calculated Column Ignore Row Context and Keep Table Filter Context?

@Vvelarde Sorry, missed the bottom portion of your post. Thank you for confirming it's not possible. Best regards!

DAX IF statement (category not on visualization)

Hey All,   How to take results of this IF statement :   FACILITIES = IF(DISTINCTCOUNT(Inventory_Snapshot[FACILITY])>1,"Multiple","Single")   Results: CATALOG_ID FACI...

Failed to save modifications to the server. Error returned: 'The expression refers to multiple colum

Hi All,   when I have upgraded version of Power bI Desktop I found out that one of my report does not open anymore with the following description:   Error Message: Failed to save modif...

Re: Import Analysis Services Tabular model into Power BI or Power Pivot

No problem, I believe we won't have luck on this, @sarsbilal84, @tljthree I have spent several hours trying to find the best ways to work with imported multidimensional and tabular cub...

Re: Problems publishing report from desktop

Thanks GilbertQ but apparently I need to be an admin for my orgs account and I’m not Is anyone else affected able to log a ticket and quote me as a +1 ?

Re: Azure Data Lake onto an Enterprise Gateway

Thanks Ibarrau that was really helpful, cant believe I missed out that little check box.   Many thanks for your help Alexander

Re: This expression refers to a Relationship object , which has an error.

Yes, I was able to get data for the columns mentioned in DAX. 

Re: printing multipage tables

I'm also looking for this. Quite annoying

Re: barcode scanner doesn't filter still...

@poej, It doesn't support to scan QR code inside a report, please vote up the following idea. https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/32585848-support-for-scanning-da...

Re: Dynamics 365 OData error with Power BI desktop

I am having trouble using v8.2 as i dont have v9 yet. I have the lates june update of Power BI. The error occurs if i try to add a new data source using the Dynamics 365 (Online). However, if i ...

Re: Row level security, live connection, SSAS, Azure AD groups

Hi @henrikf,   The Live connection is a little different that almost all the actions are processed in the SSAS server. I'm afraid it could be hard to add Azure AD groups. Maybe you can ...

How to turn randbetween results into a static column in Power Query?

I need to fabricate data in a table, so I created a number.randombetween() custom column in Power Query, which gives me what I need. However, doing anything after creates duplicate values. I'd like t...

Unable to get RLS security to work with an “app owns data” embedded PBI using Azure Analysis Service

Hello,   I am looking for some help getting RLS to work with embedded Power BI and AAS. Here is the scenario:   Deploying as App-owns-data RLS setup with roles in AAS (RLS not configu...

Re: Filling with zero values in each cell so they all have the same 4-digit-format

since you would need to do this is M, you could do something like:   =Text.End(000 & [documentnumber], 4)

Re: Dashboards and row level security

Just a further note, is if you enable RLS and you do not put anyone in the Members area, when a user logs in they will not see any data. Only when a user is added to a role, will they then see the...

Re: June release of desktop possible bugs

Hi @sqlchicken,   1. Please check if the chart is sort based on the X axis values, see:      2. This should be the issue related to Title property position o...

Re: Automatic scale

Hi @alfredomar,   Currently, automatical scale is not supported for chart visual. Here are some ideas for you to vote up. Axis Scale in charts based on formula fields Allow use of v...

Average of difference in hh:mm format

Hi All, I have 2 date fields where I am calculating difference between them like below   datediff(Replen_stats[create_date_time],Replen_stats[mod_date_time],minute)   Now if it has 5 r...