When you deploy multiple dashboards that use the same script/code (whether it data transformation in Power Query (M), a SQL statement or an R code), it is efficient to put one code in a text file, and query against the file, rather then copy/pasting the code every time you make a change. Here is...
The 'alerts' functionality in the Power BI service let's users set an 'alerts' based on a threshold. When using a KPI the target value is copied as the default threshold but when the target changes, the threshold will not be adjusted. In a scenario where you would use a YTD value to compare to...
Rankx function needs to be supported in Direct Query Mode. If I am not using Analysis Services I should be able to still create a measure of Rank and also create things like Top 10 etc..
I need the possibility to analyse (TFS) custom made work item types in Power BI. Today I only see Epics, Features, User stories and tasks. I have created a new type (spike) but I cant see that type in the Work Item table in BI. Is it possible to get this information in BI?
you need to be able to show the data value vs hovering over it to show the data values. you can show the data labels in the bar graphs but it does not apply for the geographical maps.
We recently did a poc on Power BI but reach an dangerous limit of RLS feature. As we manage data from 2 organisations, we have 3 kind of user : User with access to org A; User with access to org B; User with access to both; For now, we created a dataset using RLS to filter out the (confidential...
Make it possible to pass parameters in on the command line in addition to the pbix filename. This would allow desktop applications to open a specific pbit/pbix and set, for example, a parameter that is used in the datasource. eg: PBIDesktop.exe MyReport.pbix MyReportTemplate.pbix MyCustomParamet...
Examples: set Reference Line from a data field value (In PBI Desktop July you now call it Constant Line). set a color to a line or bar chart when a threshold is crossed Set title value of a chart from data.
When there are multiple locations the map should be able to cluster the locations based on the zoom level on the map.
It would be great if Power BI could be integrated with the Adwords and Bing Ads API for ease of reporting/tracking and analytics.