Power BI Support
Search
Re: Unable to Save or Open .pbix Documents
Hi @J_Greenwalt, I notice you already open a MSSOLVE case 117110893071382. Please wait for the response from the case owner's response. Best Regards, Qiuyun Yu
Re: Power Point Visual Timeout
Hey Dale, 1. No changes made 2. The report got 4 Pages, containing a lot of visual (4 per Page). All other visuals are exported 3. The visual is a 100% stacked bar chart with 3 Measu...
Re: Female representation within total headcount, 6 months prior - dax formula
Hi, Unfortunately that does not work, it returns blank.
Hidden columns visible after refresh
Hi, Since the july 2017 version of Power BI Desktop we encounter that all columns that where marked as 'hidden', are 'unhidden' after a refresh of the data. Is there a setting we can change ...
Re: KPI showing incidents today vs yesterday, week and month
OK, the concept was to create that column and then you could create measures for you KPI's: KPI_Today = CALCULATE(COUNT(),[DaysAgo]=0) KPI_Yesterday = CALCULATE(COUNT(
How to combine two line charts and a scatter plot ?
Hello fellow PowerBI users I am trying to create a report to display my analysis result. To do this, I have four elements: - the result of analysis ( D ec) - the min toleranc...
Re: Tachometer Visual Display - Linear instead of circular
Hello @kurtdn Does Linear Gauge by MAQ Software meet your requirements? If not, you might propose this idea at Tachometer's GitHub repository. Ignat Vilesov, Software En...
Re: How to get Net Sales and Gross Profit in the same Column/pillar in the visualization of Power BI
This is what i want. GM in the buttom of the pillar.
Re: data collected at different time interval but shown as if at same time interval
Hi @v-huizhn-msft, Thank you for your reply. My point was, it the data are on e.g Aug 1st, Aug 10th and Sep 1st, can the distance between the dots have a horizontal distance that is...
Re: Scheduled refresh failure: An item with the same key - Merged queries
Hello @mgmeyer, I've sent you a private message including an example that reproduces the error. Thank you!
Re: Cannot add a property to Format->general
I found the issue by complete chance, Apparently type must not be false (I thought it was default value) in type in capabilities, so it must be defined like. "sortByName": { ...
Re: How to group by a measure in a table?
@Vosaxalo, Create a new table using DAX below. NewTable = var tem=SUMMARIZE(Table,Table[COD],"Measure Value",[Measure]) return SUMMARIZE(tem,Table[COD],[Measure Value],"measure coun...
Re: PowerBI desktop 64Bit oracle connection error Object reference not set to an instance of an obj
I was really hoping to get away with the XCOPY version as well, as all I need to do is set it up for use by the gateway and don't want to download and install GB's but so far unsuccessful. I get all ...
Re: How to get previous Nth record Value from the specific date
Hi @hnsbhat Try this Measure for Close 1 Close 1= VAR Noofrecords = IF ( HASONEVALUE ( Table1[Dates] ), COUNTROWS ( FILTER ( ALLEXCEP...
Re: app.powerbi.com is down in the north europe
Hi All, How is the issue now? "Http 500" error is usually temporary. I guess the Service goes well again. This couldn't be a frequent issue. If you still encounter this issue, please reply. ...
Re: Knowing the uncompressed dataset size on the gateway
Has someone found a way to know what's the actual size of the "uncompressed data"? I'm still getting the message even with datasets that are way smaller than others where I don't get it...
Re: dynamic "timeperiod" report filter.
Hi, Share a dataset and show the expected result (numbers that you are expecting as results).
Re: Odata V4 Error. Couldn't parse OData response result.
Hi @v-shex-msft, When NAV 2016 introduced OData V4 support they provided a seperate URL for the V4 published web service. The only difference is the "V4" on the end of OData in the URL ...
Re: Interest Rate -Weighted Average
The DAX-measure would look like this: WAvg:=SUMX(Table1,Table1[RATE]*Table1[PERIODE])/SUM([PERIODE]) here is how it works: https://powerpivotpro.com/2012/05/weighted-averages-another-use-of-sumx/
Cumulative (running) total working with filters
Hi All, I have create a chart to capture 12 months running total of injuries. Chart works fine without filters. However, if you filter data by region/branch then caclulation stops at last re...
Re: To calculate the total dynamically
Hi, Share the download link of your file.
Re: To calculate the total dynamically
Hi, Thank you for your reply. My pbix file is having some private data.So is there any way to share it with you by hiding the data that is private?
Re: Pro License for viewing the dashboard
Hi @mkadavil Please check this link: https://powerbi.microsoft.com/en-us/documentation/powerbi-service-share-unshare-dashboard/ It's necessary for both (Developer and cust...
Re: Power Bi as a reporting tool for our web app
Hi @randyminder Sure, you can do this and more! Please check this link: https://powerbi.microsoft.com/en-us/documentation/powerbi-developer-embed-sample-app-owns-data/ You ...
Re: sum words in multiple tables, how to?
Hi, Using Query Editor, you can append data from both tables into a single one and then write this measure. =COUNTROWS(Data[Names]) Hope this helps.