Please, improve funcionalities in models with direct query. Like add calculate columns, time intelligence, and others resources. Awesome, great solution.
Idea The idea is sort of having a version of loaded data sets on which you can jump back like in a time machine to see how the data was at a certain time. Each load of data is kept as a version with the time stamp of the load. On the Report in PowerBI you can add a slider that lets you select the...
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...
Currently, we don’t support export based on in-session state. The report will be exported as it is saved. If filter was applied to the report and the report was saved this way, you will see it in the generated PPT. If it was just exploration without save, it won’t show up in the generated ppt. Th...
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..
During development, I often add the superset of data sources that I may need in the reports. After completion, I manually remove the data sources and tables that aren't used in the reports. This becomes a big effort when using a large data model, such as reporting on a data warehouse. Having the...
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.
It would be great if you could drill down in a line chart based on the content in the line chart, not the date. For example, let's say cookies, pies, and gelato are a subset of desserts. I create a line chart that shows the average profit for desserts for each month for the last six months. I th...
Allow the user to create a main page and "hyperlink" to difference sheets (and back and across sheets). The experience is then an interactive one with different screens the user can move between.