Power BI Support

Search

Calculate rows between two dates

Hi all,  I'm completely new here (and also new to power BI and DAX) And i have an issue. I want to see all my unshipped orders between a certain date (i need to be able to filter, or show a li...

Re: Using Change Tables to Compare Data

Hi, @GilbertQ, thanx!   The slicer in PBI is by far not that great than the one you have here. Can you explain, is it a custom slicer? That is, it got the same features but the one you ch...

Add data from two different data soruces in same visual

Hi everyone   I have two tables from different data sources. Data Source 1 has the data of completed sales in USD, and Data Source 2 has the data for the Closed Won where the end date is withi...

Re: Scheduled refresh failure: An item with the same key - Merged queries

@Yousra thanks for reporting this issue and it is something we are looking in to. Do you have an isolated repro that you can private mesage me to help us reproduce this on our end? Thanks!

Re: Embedded vs. Premium

much apprecaited.  I've read so many articles...  But I don't believe this is one I've seen   I should add that one of the major hurdles is being Azure (Commercial) and Power BI...

Re: DAX Distinct String

HI @DTreg1,   If you trying to get a column or table, say with unique Ref number or date then the easiest thing is in Edit query Mode:  Duplicate your table Remove columns you don...

Re: Cumulative total from multiple column

@rafieya   In this scenario, you want to calculate the cumulative total for that "forecast". Since your "forecast" value is from a measure, to apply calculation on these values, you have to ...

Re: Usage Metrics for Dashboard/Report sharing

@Till   Are the users members of the workspace where the metrics report exists? Even if they are not Pro Users I think they need to be member of workspace if you use the SharePoint web part. ...

Re: How to migrate SSRS reports to Power BI and create new reports?

Hi @vipinkmathews, We can not EDIT the reports in Power BI. If you create report in Power Bi desktop, and publish it to service, the dataset also be published to PB service, you can create ne...

Page background in App has disappeard

Hi all,   I have a report which has a picture for the background on every page.   When I look at this report in the app space, the background is completely black. It looks like the pict...

Re: Date field not spliting into Year, Quarter, Month and day

@cladeira,   Instead, drag date column from the calendar table.

Re: Unable to install On-premises data gateway

Hi  , thanks for reply i have gone through the url but not able to resolve it.Below is the screen shot what i am getting error in the pbi server.   and also check below snap,here st...

Pro License for viewing the dashboard

Do we need a Pro License for viewing the dashboard?    I am currently using Pro License to develop a dashboard. I published the report online and created a dashboard. I have to share this...

Re: IF IS FILTERED show column a when is true or b when is false

Try this, add new measure   ValueShownOnCardVisual as Measure = FIRSTNONBLANK(IF([IsFiltered]="1", Table[ColA], Table[ColB]), 1)

Re: Second to last non blank value in an array?

Hi @AGuero,     You need to use Unpivot and then use Group by functions: Unpivot and Group By Functions in Power BI Desktop     Hope this helps.     Regar...

Re: equivalent function of Networkdays in DAX

@v-shex-msft, this link is great, but I'm just learning and don't understand how to insert the measure result as a value in the new column... I have a business days value for each row of data, a...

Re: Right Y-Axis

Thank you @v-yulgu-msft, but this does not help. The slicers I use on the data cause the range to fluctuate, so I have to set the "end" value to "Auto"

Percentage symbol for Pre Calculated Measure

Hi ALL,   We have a column which has been pre caluclated in database itslef. for one code I'm getting value as 42.57. But I want to see same value as 42.57%.   When I change the foramt ...

Re: Prevent export underlying data

I have just added this as an idea as I couldn't find it already posted. You can vote here: https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/32213098-disable-export-of-underlyin...

Re: Restrict Exporting of underlying data

I have just added this as an idea as I couldn't find this one specifically already. You can vote here: https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/32213098-disable-export-...

Re: Currency format Not reflecting in PBI Service

Hi @v-shex-msft,   Thank you for the response.   Please check the pbix file here   I have exported the table and created new pbix file.   Please check and help me out &nb...

Re: Removing someone from an App does not appear to prevent them from refreshing data via Analyze in

It appears this is just a timing thing, as after about an hour the refresh no longer worked  

Re: ArcGIS maps: geocoding district issue

Hi Dale,    I am still strugglling with this. The PBI team said that they are working on this. Not sure when we can have an update to solve this problem. Did have any issue when...

Re: Report Filter on specific Values not dataset values

Hi @petersi,   In this scenario, you may need to add a new table with a single column which contains values TRUE and FALSE, and create a relationship between your source table and the n...

Re: Usage metrics not updating since the 7th?

This appears to have been resolved.