Power BI 支持

搜索

Report creation at Power Bi service to Desktop

When i created report using Power BI service online; I am not able to see the same in POWER BI Desktop for same login.  Is any setting, so that i can see the developed reports at services ...

How to Lag/shift a column of Data

Hello,   I have a question regarding lagging formulas in dax. I know there are number of diffferent time intellligence functions as well as filters that can accomplish lagging, but I am lookin...

Possible to sync matrix across pages?

I really like the sync slicers feature, however, it does not work with many custom slicer options.   Is there anyway to sync a matrix selection across pages?   If we have a matrix with ...

Sand dance with filter

Hi everyone   I'm doing a analysis of customers using Sand dance visual, I just need to see the top 20 customers.   But I'm not getting to use a visual level filters on the Sand dance, ...

Measure that averages District Office and Total Company sales per week

I have appended a table to include sales for Salespeople.  Each Salesperson belongs to a District Office.  I have included a slicer that slicers first by District Office and then Salesperso...

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

@Vvelarde When using ALL, it ignores both ROW CONTEXT and TABLE FILTER CONTEXT, so this will not achieve what I am trying to do. It computes the SUM for all rows in the table, not the current rows b...

SelectionId from data received with fetchMoreData()

I have a problem with the fetchMoreData() function. I'm able to retrieve all the data from my dataset, but when I try to generate the selectionIds, something strange happens.   I use&nbs...

Re: How to get a smaller subset?

Measure = SUMX(SUMMARIZE(Duplicate_Removal,Duplicate_Removal[NPI],"UniqNPI",AVERAGE(Duplicate_Removal[#ofService])),[UniqNPI])  

Change a value by a variable in measure

Hi everyone,   I try change this value ("3") by a variable :       EOMONTH('Data input'[Date],3)>TODAY() I want to choose with a slicer the number of month. I have ...

Re: Change a value by a variable in measure

Hi,   Try this   Selected time = MIN('Time slicer'[Time slicer])

Power BI Free vs Pro Infographic

I have been active on the Power BI Community Page for quite some time, and what I have often seen is people not quite sure what options are free and what options require a Pro license.   So he...

Re: Use slicer to filter values in at least 1 of 2 fields

Hi @mash7432   I just needed to use a different summarisation function.  Please try this calculated table instead     New Table = VAR T1 = UNION ( ...

Use slicer to filter values in at least 1 of 2 fields

Firstly, thank you for wanting to help!   I currently have data that looks something like this:   First Side Code Second Site Code Audio Video Audio Poor Video Poor ...

Text Count to Filter

Hi,   I am looking for a way to filter a text metric I have based on a distinct count. The context is that the filter is the # of orders for every client. Currently, I gather the # of orders b...

Re: England not showing on maps

You would have to write look-up logic, because it would need to stay GB behind the scenes. I think if you did a calculated column or created a grouping you'd have the same issue. 

Re: Export to excel in cross tab

Hi Team,   We are looking for similar feature in PowerBI where most of our users extract data in excel based on the cross tab calculation.    We see the solution is not comple...

Re: Normalize Data from SOL

I think I finally have the results I'm was expecting.  Does this languange have any methodololgy like .NET?    It is all copy a pasted sections with the different tables. &nb...

Re: Report creation at Power Bi service to Desktop

@zlokesh   No there is no way to do that at the moment   - Quentin

Re: Bug: Refresh MS Access datasource Lock file

Hi @weraco,   When the issue occurs, please download the report from Power BI service and open in desktop, click Refresh button to see if the same error occurs.    As the ...

Re: Trailing 12 Month Average

Hi @mrainey,   Please check out the demo in the attachment. It could be the result you want. 1. Create a date table.  2. Don't establish any relationships. 3. I would suggest...

Re: Help! No more drill down arrows in the online report version?

@UNOFOR, I am unable to reproduce this issue. Please update your Power BI Desktop to June release and check if you get this issue. Also please use different web browsers to view your report. Re...

screenshot of data while connected to a database

Hello everybody,   I am quite new to BI and my question might seem stupid. I want to build a report that can be refreshed monthly. The data comes from a cube in a datawarehouse (via Analysis S...

Re: Publishing Live Connected datasets sometimes cause Power BI Desktop to wait forever

 @Ross73312, Do you get same issue when publishing PBIX file to non-premium workspace? Could you please update the Power BI Desktop to latest version of Power BI Desktop( 2.59.5135.601 ) and ...