Provide some persistent settings for data summarisation + visualisations
I use PowerBi desktop as a quick analytics/visualisation tool for small sets of data I export to csv files as the need arises. It is intensely frustrating that every time I load a new data set PowerBI decides to auto-summarise some of the columns in my spreadsheet and I have to take a trip to th...
Provide a standard help mechanism for visualisations
PowerBI is a product I love/hate. It is clearly powerful getting it to do the right thing is often tricky. Figuring out the visualisations is often a process of reverse-engineering - particular the interpretation of the inputs fields (e.g. what is "frequency" in the histogram?). Why not provi...
Provide standard cumulative histogram
A cumulative histogram is an absolutely standard way of visualising data in a way that does not depend upon the bin size. As far as I can tell it is impossible to create this kind of chart in PowerBI without first performing some custom calculation on the underlying data but this isn't then comp...
Analytic Trend lines should show their gradients
So you can add a 'trend' line as an analytic in the line chart and it automatically fits a sensible line to the data and draws it. But then there's no way to read off the gradient or constant offset (e.g. via tooltip). Didn't it occur to anyone we might actually want to use the line rather than...
Charts with time-based x-axis should show gridlines/ticks
I often plot time-based series. If I have data that extends over 4 or 5 days the line-chart shows the dates on the x-axis but there are no ticks or gridlines indicating where each 24 hour period starts and ends. Please offer more control over the display here - ideally I'd like to be able to cu...
Provide overlay/section coloring for charts
It would be extremely useful to be able to automatically color horizontal (or even vertical) background bands of a chart by some arbitrary criteria. For example, In a time-based chart it may be desirable to use a different background for the weekend days. One way to do this might be to intr...
Provide a back/forward and history mechanism
This request refers to the desktop version of PowerBI I have a page with multiple visualisations. For example I may have a chart showing sales by location, a map showing the locations, a table showing number of staff at each location etc. When clicking on a bar in the chart or a dot on the...
visualisations (especially bar charts) should scroll to selected
If I have a chart of x vs Y and a table of X, I can click on a bar in the chart or a table entry to highlight/filter that particular X. Annoyingly though the chart/table does not scroll the highlighted item into view. This is a particular issue when there may be many values of X (in my case sev...
Allow PowerBi Desktop to be invoked with automatic "refresh" from command line
I use powerbi desktop to analyse data from another system. PowerBi can't talk to the system directly so a separate tool is used to generate csv files which PowerBi can understand. The workflow is therefore.... Use tool to generate CSV Use PowerBi to set up a report based on the CSV then on ...
Simple things to improve support for timestamped data
I often work with timestamped IOT data where I want to plot the number of events per day (or per hour or per week etc). There are a number of frustrations with this.... * The default behavior when using a DateTime field is to use the year/quarter/month/day hierarchy. I NEVER want to do this....